Question: I am getting ORA-39726 error when a
dropping a column on a non-compressed table.
ORA-39726: unsupported add/drop column operation
on compressed tables
I am confused because I did not think that this table was
compressed.
What causes are there for the ORA-39726 error?
Answer: It is not possible to get the
ORA-39726 error on a non-compressed table.
However, Oracle has had
several “types” of table compression over the years, including
column-level compression.
See here for details on
Oracle table compression errors.
The
oerr utility shows this on the ORA-39726 error:
ORA-39726: unsupported
add/drop column operation on compressed tables
Cause: An unsupported add/drop column operation
for compressed table was attempted.
Action: When adding a
column, do not specify a default value. DROP column is only
supported in the form of SET UNUSED column (meta-data drop column).
When dropping a column you can avoid the ORA-39726 error by
setting the column to unused status:
- alter table table_name set unused column
column_name
- alter table table_name drop unused columns
If you are using table compression, try moving the table into a
non-compressed format:
- alter
table table_name move nocompress;
- alter table table_name drop column
column_name;
- alter table table_name compress;
|
|
 |
|
Guarantee your Success!
Oracle is the
world's most complex, robust and flexible database, considered
impossible to master without a mentor.
That's why all BC
Oracle trainers are working professionals, experts in Oracle who
share their tips and secrets. |
|
| |
|
Burleson is the American Team
Note:
This Oracle
documentation was created as a support and Oracle training reference for use by our
DBA performance tuning consulting professionals.
Feel free to ask questions on our
Oracle forum.
Verify
experience!
Anyone
considering using the services of an Oracle support expert should
independently investigate their credentials and experience, and not rely on
advertisements and self-proclaimed expertise. All legitimate Oracle experts
publish
their Oracle
qualifications.
Errata?
Oracle technology is changing and we
strive to update our BC Oracle support information. If you find an error
or have a suggestion for improving our content, we would appreciate your
feedback. Just
e-mail:
 and include the URL for the page.
Copyright ? 1996 - 2012
All rights reserved.
Oracle ?
is the registered trademark of Oracle Corporation.
|
|
