ORA-01410 on data dictionary
- From: "Baumgartel, Paul" <paul.baumgartel@xxxxxxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 19 Jun 2006 21:29:36 +0100
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@xxxxxxxxxxxxxxxxx
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
==============================================================================
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » ORA-01410 on data dictionary
