-
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