KEMBAR78
Oracle 12c Compressing Tables On Import | PDF
Scribd
Upload
191 views1 page

Oracle 12c Compressing Tables On Import

Data Pump can now specify a different compression method during import than was used during export. This is enabled by a new TRANSFORM parameter called TABLE_COMPRESSION_CLAUSE, which allows ignoring the export compression and using the default for the tablespace, or specifying a valid compression clause like NOCOMPRESS, COMPRESS BASIC, or COMPRESS FOR OLTP. Quotation marks are needed if the compression clause has multiple words.

Uploaded by

doyenblog
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
191 views1 page

Oracle 12c Compressing Tables On Import

Data Pump can now specify a different compression method during import than was used during export. This is enabled by a new TRANSFORM parameter called TABLE_COMPRESSION_CLAUSE, which allows ignoring the export compression and using the default for the tablespace, or specifying a valid compression clause like NOCOMPRESS, COMPRESS BASIC, or COMPRESS FOR OLTP. Quotation marks are needed if the compression clause has multiple words.

Uploaded by

doyenblog
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
You are on page 1/ 1

Compressing Tables On Import

In earlier versions, Data Pump always performed an import operation using the same
compression settings that were present during the export process.
Data Pump is now enhanced to allow you to specify a compression method at import
time regardless of the compression method used when the data was exported, or if you
prefer, you can also now decompress tables during an import.
This new feature is now possible due to the introduction of a new metadata
TRANSFORM parameter called TABLE_COMPRESSION_CLAUSE. If set to NONE,
the table compression clause is ignored and it will be imported using the default
compression mode for the tablespace, or you can use any valid table compression clause
available such as: NOCOMPRESS, COMPRESS BASIC, COMPRESS FOR OLTP,
COMPRESS FOR QUERY, or COMPRESS FOR ARCHIVE.
Note: If the table compression clause has more than one word, then you must use single
or double quotation marks.
Here you can see an example of using compression on import:
$ impdp test/test DIRECTORY=datapump DUMPFILE=test.dmp
TRANSFORM=TABLE_COMPRESSION_CLAUSE:'COMPRESS FOR OLTP'

You might also like