Skip to Main Content

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!

How to export and Import table of another user from user system using expdp

555530Mar 8 2011 — edited Mar 9 2011
Hi All,


How to export a table 'scott.emp' from system user.

expdp system/password directory=expdp dumpfile=scott_emp.dmp ???? ?? tables=emp ??????????????????????????

thank you
---------------------------------------------------------- Posting solution here to make needed users not to scroll down ------------------------------------------------------
Finally I got it right!!!

Task :- Export table_1 of schema_a from database db1 and Import it to schema_b of database db2 as user other than schema owner

Solution :-

expdp system/pwd directory=expdp tables=schema_a.table_1 dumpfile=schema_a.table_1.dmp logfile=expdp_schema_a.table_1.log

impdp system/pwd directory=expdp tables=schema_a.table_1 dumpfile=schema_a.table_1.dmp logfile=impdp_schema_a.table_1.log remap_schema=schema_a:schema_b remap_tablespace=table_1_tablespace:schema_b_tablespace
-----------------------------------------------------------------------------------------------------------------
Thank You All

Edited by: Ven on Mar 9, 2011 7:52 AM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 6 2011
Added on Mar 8 2011
15 comments
2,736 views