Database Software

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!

How to exclude table data during EXPDP

johnpau2013Jan 5 2012 — edited Jun 5 2012

- we have schema SCOTT with 5 tables (emp,dept,sal,acct,loc)
- we wanted to export the entire schema using EXPDP, during export I wanted to exclude LOC table data during the export. I want the LOC table definition to be exported but NOT the data.

Give me the correct EXPDP command line with parameters to accomplish the above.

expdp scott/tiger dumpfile=scott.dmp directory=backup1 exclude = ???

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 3 2012

Added on Jan 5 2012

#database-key-features, #export-import-sql-loader-external-tables

4 comments

13,399 views