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

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

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

Oops, version is 8.1.7, which we are running on RedHat 6.2. Thanks.

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