Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 536.4K On-Premises Infrastructure
- 138.3K Analytics Software
- 38.6K Application Development Software
- 5.8K Cloud Platform
- 109.5K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
expdp compression=all basic or advanced

After read the article
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
we have:
compression=metadata_only, is free
compression=all or data_only, no free
Can you help me clear up my doubt?
Thanks.
Best Answer
-
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.
Answers
-
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.