Skip to Main Content

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 8 2012
Added on Apr 10 2012
15 comments
1,706 views