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.
Click Here to Expand Forum to Full Width