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 of tablespace

923036Apr 10 2012 — edited Apr 10 2012

Hi,

i had exported my tablespace succesfully but when i'm importing with impdp i couldn't able to load .After generating .sql for .dmp file i came know that there is
no tablespace meta_data in that sql file.then how can make this succesfull with generating ddl commands with expdp with meta_data and normal.i fired the
statement like this

expdp system/oracle dumpfile=redhat.dmp logfile=redhat.log directory=dpump tablespace=redhat

it is successfully dump file with out errors when i'm importing it's giving me error

impdp system/oracle dumpfile=redhat.dmp logfile=redhat.log directory=dpump tablespaces=redhat

Locked Post

New comments cannot be posted to this locked post.

Locked on May 8 2012

Added on Apr 10 2012

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

15 comments

1,706 views