I needed to export and import a schema from UAT to DEV, however, no mount points on the disc had enough space to accommodate the export dumpfile. Due to a lack of storage space, performing an EXPDP schema backup and compressing the dump file with GZIP or BZIP2 were not viable in my instance.
top of page
bottom of page
Beginning with 11g, you may utilise sophisticated compression methodology to instantly compress dumpfiles. Data, metadata (which is the default value), both, and none can all be compressed using this.
expdp directory=DATA_PUMP_DIR1 dumpfile=exp_disc_schema_scott.dmp logfile=exp_disc_schema_scott.log schemas=scott compression=all.Advantages:
Compression happens parallel with the export.
Compressed dumpfile can be directly used for import without decompression.
Disadvantages:
It takes more time than normal EXPDP operation. (Without compression)
Advanced Compression License option must be enabled, which is an extra cost.
This option is just available from Oracle 11g