expdp compression=all basic or advanced

Tamilio

After read the article

https://blogs.oracle.com/dbstorage/when-to-use%2c-and-not-use%2c-the-different-types-of-oracle-database-19c-data-compression

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 ?

1. Basic Table Compression
2. 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.

User_IUBBO

The compression parameter used in expdp , will only compress the dumpfile size. It has nothing to do with table or index level compression.

If you are not mentioning any compression parameter in expdp, then by default it will compress only the metadata_only, which doesn't need license.

However if you are using compression=all or data_only, then you need advanced compression license.

User_IUBBO

The compression parameter used in expdp , will only compress the dumpfile size. It has nothing to do with table or index level compression.

If you are not mentioning any compression parameter in expdp, then by default it will compress only the metadata_only, which doesn't need license.

However if you are using compression=all or data_only, then you need advanced compression license.