EXPDP of just table and type dependents

Extracting table=xxx does not extract the types needed to recreate the table at a later date - to explicitly do this you need to extract the type names too

The command should be of the form

expdp pumpy/pumpy include=TABLE:\"=\'DEPARTMENT\'\",TYPE:\"IN \(\'PROJECT\',\'PROJECTLIST\'\)\" reuse_dumpfiles=y

(all run from command line rather than pfile - hence all the \ characters to disable special meaning - you're best off using a pfile....why don't i listen to my own advice)

The objects/table definitions in the example i took from http://psoug.org/reference/varray.html


Post a Comment