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-28555: pass-through SQL: required parameter missing or NULL

1 Answers  


ORA-22957: NULL is an invalid input to powermultiset and COLLECT functions

1 Answers  


ORA-31643: unable to close dump file "string"

1 Answers  


LPX-00124: attribute value should be one or more tokens

1 Answers  


PLS-00313: 'string' not declared in this scope

1 Answers  






RMAN-06516: time specified in KEEP UNTIL clause must be be after today

1 Answers  


ORA-02240: invalid value for OBJNO or TABNO

1 Answers  


DRG-13304: character referenced by wildcard attribute is not a wildcard character, at line string

1 Answers  


PCC-00097: Use of DECIMAL and DISPLAY types allowed only for COBOL and PL/I

1 Answers  


ORA-16065: remote archival disabled at standby destination

1 Answers  


ORA-12054: cannot set the ON COMMIT refresh attribute for the materialized view

1 Answers  


ORA-39316: illegal clean_up() call: last clone operation is failed

1 Answers  


Categories