Common Questions/Top Issues Related to Compression Advisor e.g. ORA-20000, ORA-30562, ORA-00922
(Doc ID 1506214.1)
Last updated on NOVEMBER 07, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.1 and laterInformation in this document applies to any platform.
Purpose
This article intends to answer common questions about Compression Advisor, and aims to help fixing common errors while using it.
Questions and Answers
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Purpose |
| Questions and Answers |
| What is Compression Advisor |
| Where can i find the Compression Advisor, and how to use. |
| What are tables DBMS_TABCOMP_TEMP_UNCMP and DBMS_TABCOMP_TEMP_UNCMP |
| Can i disable Compression Advisor without disabling the Automatic Segment Advisor |
| Compression Advisor fails with ORA-20000: Compression Advisor must have at least 1000000 rows in this table/partition segment |
| Compression Advisor fails with ORA-30562: SAMPLE percentage must be in the range [0.000001,100) |
| Compression Advisor fails with ORA-20000: Compression Advisor TEMP UNCMP table failure |
| Compression Advisor fails with ORA-20000: For OLTP compression, specify partition (or subpartition) name for partitioned tables. |
| Compression Advisor fails with ORA-01536: space quota exceeded for tablespace 'USERS' |
| Compression Advisor fails with ORA-00922: missing or invalid option |
| Statistics collection throws error ORA-20000: Unable to set values for table DBMS_TABCOMP_TEMP_UNCMP: does not exist or insufficient privileges |
| Export (exp/expdp) errors out with ORA-00942: table or view does not exist |
| Recommended patch level |
| References |