Oracle 18c Datapump-Compression Parameter
Description:-
Default: METADATA_ONLY
Syntax and Description
COMPRESSION={ALL | DATA_ONLY | METADATA_ONLY | NONE} ALL enables compression for the entire export operation. The ALL option requires that the Oracle Advanced Compression option be enabled. DATA_ONLY results in all data being written to the dump file in compressed format. The DATA_ONLY option requires that the Oracle Advanced Compression option be enabled. METADATA_ONLY results in all metadata being written to the dump file in compressed format. This is the default. NONE disables compression for the entire export operation.
Let’s start the Demo:-
Demo:-METADATA_ONLY
[oracle@testdb datapump]$ expdp hari/hari@pdb1 DIRECTORY=test_dir DUMPFILE=demo.dmp compression=metadata_only
Export: Release 18.0.0.0.0 - Production on Sun Jul 15 03:27:41 2018
Version 18.1.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
Starting "HARI"."SYS_EXPORT_SCHEMA_02": hari/********@pdb1 DIRECTORY=test_dir DUMPFILE=demo.dmp compression=metadata_only
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
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
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/COMMENT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
. . exported "HARI"."CHENNAI" 17.08 KB 107 rows
. . exported "HARI"."DEPT" 17.08 KB 107 rows
. . exported "HARI"."EMP" 17.08 KB 107 rows
. . exported "HARI"."EMP1" 17.08 KB 107 rows
. . exported "HARI"."EMP2" 17.08 KB 107 rows
. . exported "HARI"."HR" 17.08 KB 107 rows
. . exported "HARI"."INDIA" 17.08 KB 107 rows
. . exported "HARI"."SALES" 17.08 KB 107 rows
. . exported "HARI"."SAM" 8.539 KB 512 rows
. . exported "HARI"."SYS_EXPORT_SCHEMA_01" 0 KB 0 rows
Master table "HARI"."SYS_EXPORT_SCHEMA_02" successfully loaded/unloaded
******************************************************************************
Dump file set for HARI.SYS_EXPORT_SCHEMA_02 is:
/u01/app/oracle/datapump/demo.dmp
Job "HARI"."SYS_EXPORT_SCHEMA_02" successfully completed at Sun Jul 15 03:28:43 2018 elapsed 0 00:01:01
Demo:-ALL
[oracle@testdb datapump]$ expdp hari/hari@pdb1 DIRECTORY=test_dir DUMPFILE=demo2.dmp compression=all
Export: Release 18.0.0.0.0 - Production on Sun Jul 15 03:28:49 2018
Version 18.1.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
Starting "HARI"."SYS_EXPORT_SCHEMA_02": hari/********@pdb1 DIRECTORY=test_dir DUMPFILE=demo2.dmp compression=all
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
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
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/COMMENT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
. . exported "HARI"."CHENNAI" 8.757 KB 107 rows
. . exported "HARI"."DEPT" 8.773 KB 107 rows
. . exported "HARI"."EMP" 8.781 KB 107 rows
. . exported "HARI"."EMP1" 8.765 KB 107 rows
. . exported "HARI"."EMP2" 8.773 KB 107 rows
. . exported "HARI"."HR" 8.781 KB 107 rows
. . exported "HARI"."INDIA" 8.742 KB 107 rows
. . exported "HARI"."SALES" 8.765 KB 107 rows
. . exported "HARI"."SAM" 4.765 KB 512 rows
. . exported "HARI"."SYS_EXPORT_SCHEMA_01" 0 KB 0 rows
Master table "HARI"."SYS_EXPORT_SCHEMA_02" successfully loaded/unloaded
******************************************************************************
Dump file set for HARI.SYS_EXPORT_SCHEMA_02 is:
/u01/app/oracle/datapump/demo2.dmp
Job "HARI"."SYS_EXPORT_SCHEMA_02" successfully completed at Sun Jul 15 03:29:35 2018 elapsed 0 00:00:45
Demo:-DATA_ONLY
[oracle@testdb datapump]$ expdp hari/hari@pdb1 DIRECTORY=test_dir DUMPFILE=demo3.dmp compression=data_only Export: Release 18.0.0.0.0 - Production on Sun Jul 15 03:31:19 2018 Version 18.1.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 Starting "HARI"."SYS_EXPORT_SCHEMA_02": hari/********@pdb1 DIRECTORY=test_dir DUMPFILE=demo3.dmp compression=data_only Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA 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 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/COMMENT Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT . . exported "HARI"."CHENNAI" 8.757 KB 107 rows . . exported "HARI"."DEPT" 8.773 KB 107 rows . . exported "HARI"."EMP" 8.781 KB 107 rows . . exported "HARI"."EMP1" 8.765 KB 107 rows . . exported "HARI"."EMP2" 8.773 KB 107 rows . . exported "HARI"."HR" 8.781 KB 107 rows . . exported "HARI"."INDIA" 8.742 KB 107 rows . . exported "HARI"."SALES" 8.765 KB 107 rows . . exported "HARI"."SAM" 4.765 KB 512 rows . . exported "HARI"."SYS_EXPORT_SCHEMA_01" 0 KB 0 rows Master table "HARI"."SYS_EXPORT_SCHEMA_02" successfully loaded/unloaded ****************************************************************************** Dump file set for HARI.SYS_EXPORT_SCHEMA_02 is: /u01/app/oracle/datapump/demo3.dmp Job "HARI"."SYS_EXPORT_SCHEMA_02" successfully completed at Sun Jul 15 03:31:51 2018 elapsed 0 00:00:31
Demo:-NONE
[oracle@testdb datapump]$ expdp hari/hari@pdb1 DIRECTORY=test_dir DUMPFILE=demo4.dmp compression=none
Export: Release 18.0.0.0.0 - Production on Sun Jul 15 03:33:25 2018
Version 18.1.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
Starting "HARI"."SYS_EXPORT_SCHEMA_02": hari/********@pdb1 DIRECTORY=test_dir DUMPFILE=demo4.dmp compression=none
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
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
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/COMMENT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
. . exported "HARI"."CHENNAI" 17.08 KB 107 rows
. . exported "HARI"."DEPT" 17.08 KB 107 rows
. . exported "HARI"."EMP" 17.08 KB 107 rows
. . exported "HARI"."EMP1" 17.08 KB 107 rows
. . exported "HARI"."EMP2" 17.08 KB 107 rows
. . exported "HARI"."HR" 17.08 KB 107 rows
. . exported "HARI"."INDIA" 17.08 KB 107 rows
. . exported "HARI"."SALES" 17.08 KB 107 rows
. . exported "HARI"."SAM" 8.539 KB 512 rows
. . exported "HARI"."SYS_EXPORT_SCHEMA_01" 0 KB 0 rows
Master table "HARI"."SYS_EXPORT_SCHEMA_02" successfully loaded/unloaded
******************************************************************************
Dump file set for HARI.SYS_EXPORT_SCHEMA_02 is:
/u01/app/oracle/datapump/demo4.dmp
Job "HARI"."SYS_EXPORT_SCHEMA_02" successfully completed at Sun Jul 15 03:33:56 2018 elapsed 0 00:00:30
[oracle@testdb datapump]$ ls -lrt
total 2260
-rw-r—– 1 oracle oinstall 851968 Jul 15 03:28 demo.dmp
-rw-r—– 1 oracle oinstall 245760 Jul 15 03:29 demo2.dmp
-rw-r—– 1 oracle oinstall 294912 Jul 15 03:31 demo3.dmp
-rw-r—– 1 oracle oinstall 901120 Jul 15 03:33 demo4.dmp
Catch Me On:- Hariprasath Rajaram
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 Group:https://www.linkedin.com/groups/10387079 Twitter: https://twitter.com/hariprasathdba