Dear firends,
I received the following erros, when accessing the table after table column drop !
ORA-12986: columns in partially dropped state. Submit the it 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