ORA-12986: columns in partially dropped state. Submit ALTER
TABLE DROP COLUMNS CONTINUE



ORA-12986: columns in partially dropped state. Submit ALTER TABLE DROP COLUMNS CONTINUE..

Answer / guest

Cause: An attempt was made to access a table with columns in
partially dropped state (i.e., drop column operation was
interrupted).

Action: Submit ALTER TABLE DROP COLUMNS CONTINUE to complete
the drop column operation before accessing the table.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

RMAN-08116: output filename is original SPFILE location

1 Answers  


DRG-12004: Password:

1 Answers  


ORA-29519: name string resolved via a synonym in schema string to a class with a different name

1 Answers  


ORA-38756: Flashback is already turned off for this tablespace.

1 Answers  


ORA-16033: parameter string destination cannot be the same as parameter string destination

1 Answers  


ORA-16626: failed to enable specified object

0 Answers  


PLS-00246: PARAMETER STYLE is unsupported

1 Answers  


SQL*Loader-00460: Column (string), form of use (number) does not match char set id of (number)

1 Answers  


AMD-00113: PROCEDURE string, invalid operation

1 Answers  


PLS-00150: found: string but expected : INTEGER

1 Answers  


ORA-09919: Unable to set label of dedicated server

1 Answers  


NNO-00267: warning: configuration database contains no data for server "string"

1 Answers  


Categories