Kamal Agnihotri
asked on
datapump syntax for importing a table
Originally table tab_1 was in schema_1. using DataPump, I want to move this table from schema_1 to schema_2.
The script below puts the table back into schema_1
impdp dms/DM_******@ufms020 DIRECTORY=dpump_dir_020 DUMPFILE=MOM_ALL_034.dmp LOGFILE=dmscontent_020_2 TABLES=tab_1
I have created the table in schema_2
How do I direct datapump to import tab_1 into schema_2
The script below puts the table back into schema_1
impdp dms/DM_******@ufms020 DIRECTORY=dpump_dir_020 DUMPFILE=MOM_ALL_034.dmp LOGFILE=dmscontent_020_2 TABLES=tab_1
I have created the table in schema_2
How do I direct datapump to import tab_1 into schema_2
To import from a full export file an old schema named fred, into a new schema user named barney...
With impdp:
impdp system/admin directory=dumps dumpfile=export.dmp remap_schema=fred:barney
With imp:
imp system/admin file=export.dmp fromuser=fred touser=barney
Note with impdp you need to create the directory inside Oracle:
create directory dumps as 'C:\dumps';
With impdp:
impdp system/admin directory=dumps dumpfile=export.dmp remap_schema=fred:barney
With imp:
imp system/admin file=export.dmp fromuser=fred touser=barney
Note with impdp you need to create the directory inside Oracle:
create directory dumps as 'C:\dumps';
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER