6 Replies Latest reply on Feb 6, 2007 8:15 PM by 530897

    Ora-08102 - error help me out

    444974
      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