How to do import tables and objects
1- Import a table and migrate it from one schema to another.
impdp SYSTEM/password DIRECTORY=dpump_dir1 DUMPFILE=hr.dmp REMAP_SCHEMA=hr:scott
If SCOTT account exist in the database then hr objects will be loaded into scott schema.
If scott account does not exist, then Import Utility will create the SCOTT account with an unusable password because, the dump file was exported by the user SYSTEM and imported by the user SYSTEM who has DBA privileges.
2- Import all object from one tablespace and migrate to another and also remaping schemas.
impdp user/***** DIRECTORY=DATA_PUMP_DIR DUMPFILE=export_user.dmp REMAP_TABLESPACE=TS_1:TS_2 REMAP_SCHEMA=USER1:USER2
Comments