Administration
Datapump New 11G options & features
User Rating: / 1
- Details
-
Parent Category: Articles
-
Created on Wednesday, 04 May 2011 13:37
-
Last Updated on Wednesday, 24 April 2013 15:57
-
Published on Wednesday, 04 May 2011 13:37
-
Written by Guy Lambregts
-
Hits: 7110
Datapump : some new 11G features
See also
Datapump
Datapump : Enhanced granularity with "EXCLUDE" and "INCLUDE"
Datapump Consistent
Attach to and manage running datapump jobs
Datapump has been introduced in 10G and has some advantages compared to legacy export and import (exp and imp) (and some disadvantages)
Some new features are
COMPRESSION : all, data_only, metadata_only
REUSE_DUMPFILES : overwrites old dumpfiles
Overwrite destination dump file if it exists
VERSION :
Version of objects to export.
Valid keyword values are: [COMPATIBLE], LATEST or any valid database version.
ENCRYPTION, ENCRYPTION_MODE, ENCRYPTION_PASSWORD, ENCRYPTION_ALGORITHM
DATA_OPTIONS
SOURCE_EDITION : related to editions (11G R2)
REMAP_DATA
Specify a data conversion function.
For example, REMAP_DATA=EMP.EMPNO:REMAPPKG.EMPNO.
Some gym wit the most interesting new features / options according to my experience.
[oracle@pcguy ~]$ expdp system directory=BACKUP dumpfile=expdp_SILVER.DMP schemas=TUNING compression=ALL reuse_dumpfiles=Y version='10.2.0.4' logfile=expdp_SILVER.log
Export: Release 11.2.0.2.0 - Production on Wed May 4 11:44:05 2011
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Password:
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39005: inconsistent arguments
ORA-39055: The COMPRESSION feature is not supported in version 10.2.0.4.
[oracle@pcguy ~]$ expdp system directory=BACKUP dumpfile=expdp_SILVER.DMP schemas=TUNING compression=ALL reuse_dumpfiles=Y version='11.1.0.7' logfile=expdp_SILVER.log
Export: Release 11.2.0.2.0 - Production on Wed May 4 11:45:07 2011
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Password:
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01": system/******** directory=BACKUP dumpfile=expdp_SILVER.DMP schemas=TUNING compression=ALL reuse_dumpfiles=Y version=11.1.0.7 logfile=expdp_SILVER.log
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 198.3 MB
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/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
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/VIEW/VIEW
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
. . exported "TUNING"."T_ORDER_OR" 67.86 MB 1000000 rows
. . exported "TUNING"."TJ1" 4.687 KB 2 rows
. . exported "TUNING"."TJ2" 4.695 KB 2 rows
. . exported "TUNING"."T_CURRENCY_CR" 4.726 KB 5 rows
. . exported "TUNING"."T_LOCK" 4.906 KB 5 rows
. . exported "TUNING"."T_SUPPLIER_SU" 6.335 KB 100 rows
. . exported "TUNING"."T1" 0 KB 0 rows
. . exported "TUNING"."T2" 0 KB 0 rows
. . exported "TUNING"."T3" 0 KB 0 rows
Master table "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_01 is:
/mnt/work/Data/Backup/expdp_SILVER.DMP
Job "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully completed at 11:46:13
[oracle@pcguy ~]$ expdp system directory=BACKUP dumpfile=expdp_SILVER.DMP schemas=TUNING reuse_dumpfiles=Y version='10.2.0.3'
Export: Release 11.2.0.2.0 - Production on Wed May 4 12:00:20 2011
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Password:
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01": system/******** directory=BACKUP dumpfile=expdp_SILVER.DMP schemas=TUNING reuse_dumpfiles=Y version=10.2.0.3
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 198.3 MB
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/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
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/VIEW/VIEW
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
. . exported "TUNING"."T_ORDER_OR" 136.7 MB 1000000 rows
. . exported "TUNING"."TJ1" 4.953 KB 2 rows
. . exported "TUNING"."TJ2" 4.953 KB 2 rows
. . exported "TUNING"."T_CURRENCY_CR" 4.992 KB 5 rows
. . exported "TUNING"."T_LOCK" 5.687 KB 5 rows
. . exported "TUNING"."T_SUPPLIER_SU" 25.89 KB 100 rows
. . exported "TUNING"."T1" 0 KB 0 rows
. . exported "TUNING"."T2" 0 KB 0 rows
. . exported "TUNING"."T3" 0 KB 0 rows
Master table "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_01 is:
/mnt/work/Data/Backup/expdp_SILVER.DMP
Job "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully completed at 12:01:32