ORA-39726: unsupported add/drop column operation on compressed tables

ORA-39726: unsupported add/drop column operation on compressed tables

 

解决方法：

1. 如果是空表，删除，重建即可

2. compress for all operations;

SQL> alter table test_compress compress for all operations;

Table altered.

SQL> alter table test_compress drop column object_name;

Table altered.

In 11g it is allowed to drop columns from a compressed table IF compatible is set to 11.1 or higher AND table was created with the "compress for all operations" option.
3.  set column unused

SQL> alter table test_compress compress;

SQL> alter table test_compress drop column object_id;
alter table test_compress drop column object_id
                                      *
ERROR at line 1:
ORA-39726: unsupported add/drop column operation on compressed tables

SQL> alter table test_compress set unused(object_id);