DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Getting unique constraint (SYS.I_OBJ1) violated on table creation

  1. #1
    Join Date
    Feb 2007
    Posts
    2

    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.

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Try

    drop table xyz purge;

    or

    purge tablespace system;

    Do you see invalid objects in the sys schema?

    If it does not work, contact oracle support;


    Tamil

  3. #3
    Join Date
    Feb 2007
    Posts
    2
    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.

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    sounds like somebody twiddled with your data dictionary.
    Jeff Hunter

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width