Unused Columns Count against 1000-column Table Limit Causing ORA-01792 on Compressed Table
Last updated on MAY 17, 2017
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 and later
Information in this document applies to any platform.
Columns cannot be physically dropped from compressed tables. This is not a bug.
- If the compression type is BASIC, you will get an error: ORA-39726: unsupported add/drop column operation on compressed tables.
- If the compression type is an advanced-compression type, such as OLTP, the drop column succeeds, but internally it marks the column as unused (i.e. hidden) and does not physically drop it.
- Unused columns count against the 1000-column limit for tables in an Oracle database. The total count of columns that count against this limit can be obtained by getting a count from DBA_TAB_COLS.
A column was dropped from a table compressed with advanced table compression.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms