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

LFI-00127: No Record Format was specified, default is variable.

1 Answers  


ORA-08189: cannot flashback the table because row movement is not enabled

2 Answers  


RMAN-10028: network error number-number occurred during remote RPC

1 Answers  


ORA-24812: character set conversion to or from UCS2 failed

1 Answers  


ORA-08271: sksabln: Buffer size not large enough for archive control string

1 Answers  






ORA-25446: duplicate column value for table alias: string, column: string

1 Answers  


PCC-02422: Invalid value specified for the given context option

1 Answers  


NNL-00266: Round trip time is string

1 Answers  


O2I-00126: You must specify an INTYPE file with SCHEMA_NAMES=FROM_INTYPE

1 Answers  


SQL-02127: Precompiler/SQLLIB version mismatch

1 Answers  


LFI-00120: Unable to parse root filename string.

1 Answers  


ORA-39150: bad flashback time

1 Answers  


Categories