Database Administration (MOSC)

MOSC Banner

ORA-08102: index key not found, obj# 1331377, file 2, block 248304 (2)

edited Jan 22, 2012 9:07PM in Database Administration (MOSC) 5 comments
Hi

When i purging the recyclebin we are getting the below error

ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-08102: index key not found, obj# 1331377, file 2, block 248304 (2)
Database is11g
application end  os oracle apps
when ia check the object is 
INDEX_NAME                     INDEX_TYPE                  TABLE_NAME                     TABLESPACE_NAME               
------------------------------ --------------------------- ------------------------------ ------------------------------ --------------- ---------- -------- ---
RECYCLEBIN$_OBJ                NORMAL                      RECYCLEBIN$                    SYSTEM
now help me how how do i purge the recyclebinThanksShashikanth 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center