REMAP_SCHEMA :
- To move a schema from one database to another.
- It is not mandatory to have the target schema in the database. If the target schema does not exist the impdp will create the target schema, provided the impdp invoking user has sufficient privileges to create the user in the database.
[oracle@18c empdata]$ impdp system/oracle directory=test_dir dumpfile=hari_data.dmp logfile=hari_data.log remap_schema=hari:sam Import: Release 18.0.0.0.0 - Production on Wed Aug 22 00:32:48 2018 Version 18.3.0.0.0 Copyright (c) 1982, 2018, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production Master table "SYSTEM"."SYS_IMPORT_FULL_01" successfully loaded/unloaded Starting "SYSTEM"."SYS_IMPORT_FULL_01": system/******** directory=test_dir dumpfile=hari_data.dmp logfile=hari_data.log remap_schema=hari:sam Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA Processing object type SCHEMA_EXPORT/TABLE/TABLE Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA . . imported "SAM"."EMP" 873.1 KB 100000 rows . . imported "SAM"."SYS_EXPORT_SCHEMA_04" 796.5 KB 1484 rows . . imported "SAM"."SYS_EXPORT_SCHEMA_03" 615.3 KB 1463 rows . . imported "SAM"."SYS_EXPORT_SCHEMA_02" 434.3 KB 1445 rows . . imported "SAM"."SYS_EXPORT_SCHEMA_01" 0 KB 0 rows Processing object type SCHEMA_EXPORT/TABLE/COMMENT Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS Processing object type SCHEMA_EXPORT/STATISTICS/MARKER Job "SYSTEM"."SYS_IMPORT_FULL_01" successfully completed at Wed Aug 22 00:33:07 2018 elapsed 0 00:00:19
Catch Me On:- Hariprasath Rajaram
Telegram:https://t.me/joinchat/I_f4DhGF_Zifr9YZvvMkRg
LinkedIn:https://www.linkedin.com/in/hari-prasath-aa65bb19/
Facebook:https://www.facebook.com/HariPrasathdba
FB Group:https://www.facebook.com/groups/894402327369506/
FB Page: https://www.facebook.com/dbahariprasath/?
Twitter: https://twitter.com/hariprasathdba
