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 export datbase with exp command

manujapandayFeb 10 2012 — edited Feb 10 2012

Hi guys,

How to export oracle database using exp command without including tables space names.

I tried with this
./exp username/password file=db-export.dmp
./imp username/password file=db-export.dmp full=y ignore=y

But when I try to import database with separate login(username/password) its giving following error for some tables,

ORA-00959: tablespace 'MANUJA' does not exist
MANUJA is my username of first database

any help ?

Thanks
Best Regards,
Manuja

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 9 2012

Added on Feb 10 2012

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

4 comments

2,301 views