CODEWITHSUNDEEP
sqloracle-databaseoracle-sqldeveloper
James J
James J

Reputation: 79

Cannot drop table SQL Error: ORA-00600

I edited a table in SQL Developer, changing its identity column to start with 0. Upon pressing ok, I can no longer make an changes the identity column and I cannot even drop the table because of this. I get the error message:

SQL Error: ORA-00600: internal error code, arguments: [12811], [92006], [], [], [], [], [], [], [], [], [], []
00600. 00000 -  "internal error code, arguments: [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s]"

Putting 0 for start with for the identity column always causes this.

How can I remove this table?

EDIT: so this is the code:

CREATE TABLE T1(ID NUMBER GENERATED ALWAYS AS IDENTITY);
ALTER TABLE T1 MODIFY ID GENERATED ALWAYS AS IDENTITY; --fine
ALTER TABLE T1 MODIFY ID GENERATED ALWAYS AS IDENTITY START WITH 0; --SQL Error: ORA-00600     and you can no longer drop table or alter column

Upvotes: 3

Views: 2326

Answers (1)

Roman Sinyakov
Roman Sinyakov

Reputation: 606

I have been encountering this issue occasionally likely because of frequent ALTER TABLE table MODIFY identity_column GENERATED BY ... statements(due to my needs). I workaround this by renaming the original table(it works well), creating a new one(with a proper name) and moving all the data into the new one.

Upvotes: 1

Related Questions