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);