HOW to (IMPORT) IMPDP DATA from onE schema to another schema IN ORACLE DATABASE 10G
====================================================================================
impdp scott/tiger@stlbas_105 schemas=SCOTT directory=dir_stlbas dumpfile=stelar.dmp logfile=stelar_tables.log remap_schema=SCOTT:HR
-----table from one schema to another schema
impdp scott/tiger@stlbas_105 tables=SCOTT.EMP directory=dir_stlbas dumpfile=stelar.dmp logfile=stelar_tables.log remap_schema=SCOTT:HR
see more here
http://www.oracle-base.com/articles/10g/OracleDataPump10g.php
====================================================================================
impdp scott/tiger@stlbas_105 schemas=SCOTT directory=dir_stlbas dumpfile=stelar.dmp logfile=stelar_tables.log remap_schema=SCOTT:HR
-----table from one schema to another schema
impdp scott/tiger@stlbas_105 tables=SCOTT.EMP directory=dir_stlbas dumpfile=stelar.dmp logfile=stelar_tables.log remap_schema=SCOTT:HR
see more here
http://www.oracle-base.com/articles/10g/OracleDataPump10g.php
No comments:
Post a Comment