Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

datapump

ReposMar 17 2009 — edited Mar 17 2009

HI
Oracle version 10.1.0.4.0 (Red Hat Linux)
I use datapump export to export one schema and need to exclude 20 tables, when i add this 20 tables in the list
it through a "Segmentation fault" I check in the metalink and it is bug (Doc ID: 551194.1 )
They advise to apply a patch 10.1.0.5 or use multiple exclude parameter

I try the second option but it is not working , hot i can run this the expdp parameter which i run is like this

expdp orcale/orac schemas=vdb EXCLUDE=TABLE:\"IN \(\'PO_TEMP\',\'S_TEMP\',\'EVENTS_TEMP\',\'REF_TEMP\'\)\" EXCLUDE=TABLE:\"IN \(\'STTEMP\',\'DIMTEMP\',\'M_TEMP\',\'M_ID_TEMP\'\)\" EXCLUDE=TABLE:\"IN \(\'C_TEMP\',\'TTC\',\'P_TEMP\,\'LOAD_TEST1\'\)\" directory=datapump_dir PARALLEL=4 logfile=test.log dumpfile=test1.dmp

RDS

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 14 2009

Added on Mar 17 2009

#general-database-discussions

8 comments

612 views