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

PCC-02388: Arrays not allowed in FROM/WHERE clause of SELECT statement

1 Answers  


ORA-22345: recompile type string.string before attempting this operation

1 Answers  


ORA-25264: cant get signature for this queue

1 Answers  


ORA-33072: (XSAGDNGL35) In AGGMAP workspace object, the hierarchy dimension QDR over dimension workspace object must be specified for every relation dimensioned by that hierarchy dimension.

1 Answers  


ORA-07581: spstp: cannot derive SID from unexpected process name

1 Answers  






TNS-00023: INTCTL: missing ADDRESS(es) in config files

1 Answers  


ORA-12235: TNS:Failure to redirect to destination

1 Answers  


NZE-29249: an unrecognized state was passed to a cryptographic function

1 Answers  


DRG-10203: server named string does not exist

1 Answers  


ORA-38455: Expression Filter index should be created by the owner.

1 Answers  


ORA-16232: adding Logical Standby skip entry for table string.string

1 Answers  


RMAN-08526: channel string: string

1 Answers  


Categories