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!

Expdp Table Level

AKPTDec 16 2013 — edited Dec 16 2013

Oracle 11gR2

Unix

I am using below command >>expdp directory=dir1 dumfile=dump1.dmp logfile =log1.log tables=SCOTT.EMP

I have created 1 view and 1 index on this emp table.

In doc it's mentioned that "AT TABLE LEVEL EXPORT TABLE AND IT'S DEPENDENT OBJECTS WILL BE EXPORTED"

But in dumpfile i could not find that index and views.

Please let me know which dependent objects will be unloaded with table.

Thanks,

AKPT

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 13 2014

Added on Dec 16 2013

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

4 comments

506 views