ORA-21561: OID generation failed
Hello,
I get error ORA-21561: OID generation failed each time when i drop table via statement
DROP TABLE MYSCHEMA.MYTABLE CASCADE CONSTRAINT;
any idea why? some tables are dropping without any issues.
output from script...
Start Drop Tables before drop user schema....
DROP TABLE MYSCHEMA.MYTAB CASCADE CONSTRAINT
DROP TABLE MYSCHEMA.MYANOTHERTABBLE CASCADE CONSTRAINT
DROP TABLE MYSCHEMA.ANDANOTHER CASCADE CONSTRAINT
DROP TABLE MYSCHEMA.ANDANOTHER CASCADE CONSTRAINT
DROP TABLE MYSCHEMA.MYTABLEA CASCADE CONSTRAINT
Creation of MYSCHEMA initial database failed! Script:DROP TABLE
MYSCHEMA.MYTABLEA CASCADE CONSTRAINT Found (0) v$session.
Found (0) v$process.
DECLARE
*
ERROR at line 1:
ORA-21561: OID generation failed
ORA-06512: at line 210