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

ORA-19909: datafile string belongs to an orphan incarnation

2 Answers  


ORA-06731: TLI Driver: cannot alloc t_call

1 Answers  


ORA-38418: ADT associated with the attribute set string does not exist

1 Answers  


ORA-38950: Source platform string not cross platform compliant

1 Answers  


ORA-32603: invalid FREEPOOLS LOB storage option value

1 Answers  






LSX-00149: duplicated ID specified in "~S"

1 Answers  


ORA-23407: object name string must be shaped like "schema"."object" or "object"

1 Answers  


ORA-00721: changes by release string cannot be used by release string

1 Answers  


ORA-00830: cannot set statistics_level to BASIC with auto-tune SGA enabled

1 Answers  


ORA-01189: file is from a different RESETLOGS than previous files

1 Answers  


ORA-39078: unable to dequeue message for agent string from queue "string"

1 Answers  


CLSR-00002: Oracle error encountered while executing string

1 Answers  


Categories