[oracle@dba1 rman]$ expdp dumpfile=1.dmp logfile=1.log schemas=VENKY COMPRESSION=ALL
Export: Release 11.2.0.3.0 - Production on Wed Jan 24 21:37:07 2018
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Username: / as sysdba
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SYS"."SYS_EXPORT_SCHEMA_01": /******** AS SYSDBA dumpfile=1.dmp logfile=1.log schemas=VENKY COMPRESSION=ALL
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 320 KB
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
. . exported "VENKY"."BONUS" 5.593 KB 896 rows
. . exported "VENKY"."DEPT" 4.984 KB 4 rows
. . exported "VENKY"."DUMMY" 4.687 KB 1 rows
. . exported "VENKY"."EMP" 5.632 KB 14 rows
. . exported "VENKY"."SALGRADE" 4.898 KB 5 rows
Master table "SYS"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYS.SYS_EXPORT_SCHEMA_01 is:
/u01/app/oracle/admin/prd/dpdump/1.dmp
Job "SYS"."SYS_EXPORT_SCHEMA_01" successfully completed at 21:38:12
[oracle@dba1 rman]$
[oracle@dba1 rman]$ cd /u01/app/oracle/admin/prd/dpdump/
[oracle@dba1 dpdump]$ ll
total 104
-rw-r----- 1 oracle oinstall 94208 Jan 24 21:38 1.dmp
-rw-r--r-- 1 oracle oinstall 1592 Jan 24 21:38 1.log
-rw-r----- 1 oracle oinstall 116 Nov 12 14:48 dp.log
[oracle@dba1 dpdump]$ impdp dumpfile=1.dmp logfile=1.log remap_schema=VENKY:MANI
Import: Release 11.2.0.3.0 - Production on Wed Jan 24 21:40:39 2018
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Username: / as sysdba
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "SYS"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "SYS"."SYS_IMPORT_FULL_01": /******** AS SYSDBA dumpfile=1.dmp logfile=1.log remap_schema=VENKY:MANI
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 "MANI"."BONUS" 5.593 KB 896 rows
. . imported "MANI"."DEPT" 4.984 KB 4 rows
. . imported "MANI"."DUMMY" 4.687 KB 1 rows
. . imported "MANI"."EMP" 5.632 KB 14 rows
. . imported "MANI"."SALGRADE" 4.898 KB 5 rows
Job "SYS"."SYS_IMPORT_FULL_01" successfully completed at 21:40:46
[oracle@dba1 dpdump]$
Export: Release 11.2.0.3.0 - Production on Wed Jan 24 21:37:07 2018
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Username: / as sysdba
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SYS"."SYS_EXPORT_SCHEMA_01": /******** AS SYSDBA dumpfile=1.dmp logfile=1.log schemas=VENKY COMPRESSION=ALL
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 320 KB
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
. . exported "VENKY"."BONUS" 5.593 KB 896 rows
. . exported "VENKY"."DEPT" 4.984 KB 4 rows
. . exported "VENKY"."DUMMY" 4.687 KB 1 rows
. . exported "VENKY"."EMP" 5.632 KB 14 rows
. . exported "VENKY"."SALGRADE" 4.898 KB 5 rows
Master table "SYS"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYS.SYS_EXPORT_SCHEMA_01 is:
/u01/app/oracle/admin/prd/dpdump/1.dmp
Job "SYS"."SYS_EXPORT_SCHEMA_01" successfully completed at 21:38:12
[oracle@dba1 rman]$
[oracle@dba1 rman]$ cd /u01/app/oracle/admin/prd/dpdump/
[oracle@dba1 dpdump]$ ll
total 104
-rw-r----- 1 oracle oinstall 94208 Jan 24 21:38 1.dmp
-rw-r--r-- 1 oracle oinstall 1592 Jan 24 21:38 1.log
-rw-r----- 1 oracle oinstall 116 Nov 12 14:48 dp.log
[oracle@dba1 dpdump]$ impdp dumpfile=1.dmp logfile=1.log remap_schema=VENKY:MANI
Import: Release 11.2.0.3.0 - Production on Wed Jan 24 21:40:39 2018
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Username: / as sysdba
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "SYS"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "SYS"."SYS_IMPORT_FULL_01": /******** AS SYSDBA dumpfile=1.dmp logfile=1.log remap_schema=VENKY:MANI
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 "MANI"."BONUS" 5.593 KB 896 rows
. . imported "MANI"."DEPT" 4.984 KB 4 rows
. . imported "MANI"."DUMMY" 4.687 KB 1 rows
. . imported "MANI"."EMP" 5.632 KB 14 rows
. . imported "MANI"."SALGRADE" 4.898 KB 5 rows
Job "SYS"."SYS_IMPORT_FULL_01" successfully completed at 21:40:46
[oracle@dba1 dpdump]$
No comments:
Post a Comment