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!

Export Import with different tablespaces

656573Apr 22 2009 — edited Apr 22 2009

Does anyone know if there is a way to export from one database (creating a dmp file) and then importing into another database with different tablespaces? I have tried this and get this error:
ORA 959. It complained that the tablespace doesnt exist (which it doesnt). Is there a way I can change the export or import parameters to avoid this and just use the default tablespaces?

I may well be missing the point here so please feel free to tell me I am being a fool.

Thanks
Johan

This post has been answered by Pavan DBA on Apr 22 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 20 2009

Added on Apr 22 2009

#general-database-discussions

10 comments

694 views