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