Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

expdp compression=all basic or advanced

TamilioAug 23 2021

After read the article
When to Use, and Not Use, the Different Types of Oracle Database 19c Data Compression (0 Bytes)i have a doubt. In our database Enterprise Edition we have only tables and indexes created without COMPRESS.
What is the compression used internally by expdp with compression=all option ?
Basic Table Compression
Advanced Compression
The first is free, the second not.
The Oracle doc
https://docs.oracle.com/en/database/oracle/oracle-database/19/sutil/oracle-data-pump-export-utility.html#GUID-C0122FE3-71EE-4E10-8F2A-03687227292C
we have:
compression=metadata_only, is free
compression=all or data_only, no free

Can you help me clear up my doubt?
Thanks.

This post has been answered by User_IUBBO on Aug 30 2021
Jump to Answer
Comments
Post Details
Added on Aug 23 2021
3 comments
16,572 views