Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Ora-08102 - error help me out

444974Feb 6 2007 — edited Feb 6 2007
dear all,

Im getting ora-8102 error
"ORA-00604: error occurred at recursive SQL level 1
ORA-08102: index key not found, obj# 49, file 47, block 25578 (2)" while im creating index on newly created table . I found the suggestion doc from metalink for the same. but it didn't work. because the obj#49 is the index (I_CON2) which related to table CON$. so im not able to rebuild the index as suggested in metalink.

Im getting the same erorr for all schema even creating new table with constraints.

Thanks
mohan

Comments

Kamal Kishore
Have you contacted Oracle Support on this?



ORA-08102 index key not found, obj# string, dba string (string)

Cause: This is an internal error; possible inconsistency in index.

Action: Send trace file to Oracle Support Services, along with information on reproducing the error.
Eduardo Legatti

Hi,

>>so im not able to rebuild the index as suggested in metalink.
Why not ? Did you try and received an error ?

SYS@ORACLE10> select owner,index_name,table_name,status from dba_indexes where index_name='I_CON2';

OWNER      INDEX_NAME       TABLE_NAME         STATUS
---------- ---------------- ------------------ ----------
SYS        I_CON2           CON$               VALID

Cheers

Kamal Kishore

Why not ?

Just a guess, since there is no error message from OP, Probably because:

SQL> alter index I_CON2 rebuild ;
alter index I_CON2 rebuild
*
ERROR at line 1:
ORA-00701: object necessary for warmstarting database cannot be altered


SQL> disc
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.7.0 - Production
SQL>
Eduardo Legatti
Hi,

>>Just a guess
Well, me too because the action was suggested in metalink as OP said.

Cheers
444974
yes im getting the same result while executing your query
530897
If you can reproduce the error and have found no notes on Metalink that either match your problem or do not resolve the problem, you should consider creating an SR with Oracle Support to help you find a resolution.
1 - 6
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 6 2007
Added on Feb 6 2007
6 comments
1,154 views