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
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
Comments
Post a Comment