Wednesday, June 29, 2011

HOW (IMPORT) IMPDP DATA from onE schema to another schema IN ORACLE DATABASE 10G

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

No comments: