Getting unique constraint (SYS.I_OBJ1) violated on table creation
For a background, I'm using Oracle 10g (at the moment, I'm unsure about the minor numbers), and connecting via JDBC.
I'm not sure what has happened to this tablespace, but Oracle is giving me some serious grief.
As an example, I verify that table "xyz" does not exist. I even run:
drop table xyz
And get an error that it doesn't exist.
I then attempt to create a very simple table:
create table xyz ( dimid int )
And Oracle comes back with:
ORA-00604: error occurred at recursive SQL level 1
ORA-00001: unique constraint (SYS.I_OBJ1) violated, SQL State: 60000, Error Code: 604
Does anyone have an idea about what the problem could be, and possibly how to fix it beyond creating a new tablespace? Thanks in advance.
drop table xyz purge;
purge tablespace system;
Do you see invalid objects in the sys schema?
If it does not work, contact oracle support;
Thanks for the response.
Unfortunately, none of this seemed to work. On the other hand, I'm fortunate that this error occured on a test server that was about to get a re-install of Oracle to switch over the character set.
If I see this again, I'll definitely contact Oracle support.
sounds like somebody twiddled with your data dictionary.
Click Here to Expand Forum to Full Width