Datapump Import Schema Level
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Datapump Import Schema Level as PDF for free.
More details
- Words: 221
- Pages: 1
Data pump:Import---->Schema Level ---------------------------------Description: ------------This dumpfile scott.dmp exported from "orcl" database.Here i exported three schemas like scott,test1,test2.Now i import these three schemas into "doyen" database which is in the same in machine. Syntax: ------[oracle@sys34 ~]$ impdp system/oracle directory=data_pump_dir dumpfile=scott.dmp schemas=scott,test1,test2 table_exists_action=replace Logfile: -------Import: Release 10.2.0.1.0 - Production on Tuesday, 26 August, 2008 10:31:41 Copyright (c) 2003, 2005, Oracle.
All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 Production With the Partitioning, OLAP and Data Mining options Master table "SYSTEM"."SYS_IMPORT_SCHEMA_01" successfully loaded/unloaded Starting "SYSTEM"."SYS_IMPORT_SCHEMA_01": system/******** directory=data_pump_dir dumpfile=scott.dmp schemas=scott,test1,test2 table_exists_action=replace Processing object type SCHEMA_EXPORT/USER Processing object type SCHEMA_EXPORT/SYSTEM_GRANT Processing object type SCHEMA_EXPORT/ROLE_GRANT Processing object type SCHEMA_EXPORT/DEFAULT_ROLE 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 "SCOTT"."WELCOME1" 709.2 KB 65536 rows . . imported "SCOTT"."CUST" 5.296 KB 3 rows . . imported "SCOTT"."DEPT" 5.656 KB 4 rows . . imported "SCOTT"."EMP" 7.820 KB 14 rows . . imported "SCOTT"."SALGRADE" 5.585 KB 5 rows . . imported "TEST1"."TABLE1" 5.296 KB 3 rows . . imported "TEST2"."TABLE2" 5.312 KB 4 rows . . imported "SCOTT"."BONUS" 0 KB 0 rows . . imported "TEST1"."TABLE2" 0 KB 0 rows Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT 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/CONSTRAINT/REF_CONSTRAINT Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS Job "SYSTEM"."SYS_IMPORT_SCHEMA_01" successfully completed at 10:31:46
All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 Production With the Partitioning, OLAP and Data Mining options Master table "SYSTEM"."SYS_IMPORT_SCHEMA_01" successfully loaded/unloaded Starting "SYSTEM"."SYS_IMPORT_SCHEMA_01": system/******** directory=data_pump_dir dumpfile=scott.dmp schemas=scott,test1,test2 table_exists_action=replace Processing object type SCHEMA_EXPORT/USER Processing object type SCHEMA_EXPORT/SYSTEM_GRANT Processing object type SCHEMA_EXPORT/ROLE_GRANT Processing object type SCHEMA_EXPORT/DEFAULT_ROLE 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 "SCOTT"."WELCOME1" 709.2 KB 65536 rows . . imported "SCOTT"."CUST" 5.296 KB 3 rows . . imported "SCOTT"."DEPT" 5.656 KB 4 rows . . imported "SCOTT"."EMP" 7.820 KB 14 rows . . imported "SCOTT"."SALGRADE" 5.585 KB 5 rows . . imported "TEST1"."TABLE1" 5.296 KB 3 rows . . imported "TEST2"."TABLE2" 5.312 KB 4 rows . . imported "SCOTT"."BONUS" 0 KB 0 rows . . imported "TEST1"."TABLE2" 0 KB 0 rows Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT 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/CONSTRAINT/REF_CONSTRAINT Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS Job "SYSTEM"."SYS_IMPORT_SCHEMA_01" successfully completed at 10:31:46
Related Documents
Datapump Import Schema Level
October 2019 7
Datapump Import Table Level
October 2019 10
Datapump Export Schema Level
October 2019 7
Datapump Import Full Database
October 2019 7
