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.
You haven't said which version so I've assumed 9.2, you should be able to rebuild the index by using
ALTER INDEX SYS.i_OBJ2 REBUILD;
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 );
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!
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)
"There is a difference between knowing the path and walking the path."
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?
Click Here to Expand Forum to Full Width