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

Thread: ORA-01578 index I_OBJ2

  1. #1
    Join Date
    Mar 2003
    Posts
    3

    ORA-01578 index I_OBJ2

    We have a corrupted block in system01.dbf, analysis of which says it is an index I_OBJ2 on table OBJ$ in the SYSTEM tablespace owned by SYS. According to the documentation I've been able to find on resolving this issue, I should be able to drop and recreate the index. Can someone provide the proper syntax for recreating this particular index? TIA.

    Jim

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    You haven't said which version so I've assumed 9.2, you should be able to rebuild the index by using

    Code:
    ALTER INDEX SYS.i_OBJ2 REBUILD;
    if not

    Code:
    CREATE UNIQUE INDEX SYS.I_OBJ2 ON 
      "SYS".OBJ$(OWNER#, NAME, NAMESPACE, REMOTEOWNER, LINKNAME, SUBNAME) 
      TABLESPACE SYSTEM PCTFREE 10  STORAGE(INITIAL 16384 NEXT 106496 PCTINCREASE 0 );
    HTH
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  3. #3
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Code:
    CREATE UNIQUE INDEX "SYS"."I_OBJ2" ON "SYS"."OBJ$" ("OWNER#", "NAME", "NAMESPACE", "REMOTEOWNER", "LINKNAME", "SUBNAME")
      PCTFREE 10 INITRANS 2 MAXTRANS 255
      STORAGE(INITIAL 16384 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
    
      PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
      TABLESPACE "SYSTEM"
    HTH
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  4. #4
    Join Date
    Mar 2003
    Posts
    3
    Oops, version is 8.1.7, which we are running on RedHat 6.2. Thanks.

  5. #5
    Join Date
    Mar 2003
    Posts
    3
    In trying to drop the I_OBJ2 index I encountered this error:

    ORA-00701: object necessary for warmstarting database cannot be altered

    Is there a way around this problem?

    Jim

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