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
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,161 views