ORA-01410 on data dictionary

From: Baumgartel, Paul <paul.baumgartel_at_credit-suisse.com>
Date: Mon, 19 Jun 2006 21:29:36 +0100
Message-ID: <D97D1FAE0521BD44820B920EDAB3BBAC0F40E36F@ENYC11P32005.corpny.csfb.com>

I recently copied a database by restoring a hot backup on another machine, creating a new controlfile with new DB name, and recovering. All went normally but we are now getting ORA-01410: Invalid rowid on some data dictionary queries. ANALYZE INDEX ...VALIDATE STRUCTURE on SYS indexes reveals

SQL> analyze index sys.I_COL1 validate structure; analyze index sys.I_COL1 validate structure
*

ERROR at line 1:
ORA-08103: object no longer exists

This index apparently is created at bootstrap time and can't be rebuilt:

SQL> alter index sys.I_COL1 rebuild;
alter index sys.I_COL1 rebuild
*

ERROR at line 1:
ORA-00701: object necessary for warmstarting database cannot be altered

Has anyone seen this?

9.2.0.6 on Solaris / SunOS 5.8.

Thanks,

Paul Baumgartel
CREDIT SUISSE
Information Technology
DBA & Admin - NY, KIGA 1
11 Madison Avenue
New York, NY 10010
USA
Phone 212.538.1143
paul.baumgartel_at_credit-suisse.com
www.credit-suisse.com

---

Please access the attached hyperlink for an important electronic communications disclaimer:

http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html

---

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Jun 19 2006 - 15:29:36 CDT