You are currently browsing the tag archive for the ‘ORA-39726: unsupported add/drop column operation on compressed tables’ tag.

You can hit this error during drop column on your compressed tables

For the 10.2 there is no solution for this error. But there are some options to workaround for can pass this error.

These are:

Upgrade your db to 11gR2
Can keep unused columns on tables
You may recreate table without such columns which you try to drop
Do not to use compress

Read the rest of this entry »