Friday, 9 November 2012

HOW to (IMPORT) IMPDP DATA from one schema to another schema IN ORACLE DATABASE 10G & 11G

I want export data from below two tables from one schema & Import to Another schema


Export Commands:-

expdp DIRECTORY=EXPPUMP TABLES=SUNIL.COLUMN_DATA_TYPE,SUNIL.TIME_ZONES CONTENT=DATA_ONLY DUMPFILE=TABLES.dmp

-----table from one schema to another schema
----- IMPORT THOSE ABOVE TABLES TO KUMAR SCHEMA WHICH WAS EXPORTED FROM SUNIL SCHEMA 

impdp DIRECTORY=EXP_DP full=y DUMPFILE=TABLES.dmp REMAP_SCHEMA=SUNIL:KUMAR

It will directly imported to those two tables to KUMAR Schema.

No comments:

Post a Comment