Forum Stats

  • 3,759,244 Users
  • 2,251,515 Discussions
  • 7,870,550 Comments

Discussions

ORA-12986 ORA-00955 error after table column drop

orasiya
orasiya Member Posts: 427 Bronze Badge
edited Mar 12, 2021 11:01PM in Forms

dear firends,

I reveieved the following erros, when accessing to table after table column drop !

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

ORA-00955: name is already used by an existing object

our database version is 18c (Exadata 7)

none of the following commands soloved our problems,

ALTER TABLE myTable DROP COLUMNS CONTINUE

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


ALTER TABLE myTable DROP COLUMNS continue CHECKPOINT 250;

ORA-00955: name is already used by an existing object

any idea?


regards

Tagged:

Answers