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@(protected)
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