Database Administration (MOSC)

MOSC Banner

ORA-21561: OID generation failed

edited Jan 22, 2018 7:00AM in Database Administration (MOSC) 2 commentsAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center