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



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

Answer / guest

Cause: An unsupported add/drop column operation for
compressed table was attemped.

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

Please add more information about this Error

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-39137: cannot specify a TABLE_EXISTS_ACTION of string for a job with no metadata

1 Answers  


LCD-00128: invalid positional parameter value [string]

1 Answers  


RMAN-06467: could not translate DBA: number

1 Answers  


ORA-13033: Invalid data in the SDO_ELEM_INFO_ARRAY in SDO_GEOMETRY object

1 Answers  


RMAN-06159: error while looking up backup set

1 Answers  






NNL-00905: NOT AUTHORITY responses sent: number

1 Answers  


LPX-00604: Invalid attribute value '~1S', for attribute '~2s'.

1 Answers  


DRG-12003: Please enter username for this FTP server:

1 Answers  


NNL-00301: Server shutting down

1 Answers  


ORA-38474: attribute set may not have attributes of TABLE COLLECTION type.

1 Answers  


ORA-24323: value not allowed

1 Answers  


ORA-22995: TABLESPACE DEFAULT option is invalid in this context

1 Answers  


Categories