Database Administration (MOSC)

MOSC Banner

ORA-08102: index key not found, obj# 39, file 1, block 280372 (2)

edited Feb 27, 2019 1:39PM in Database Administration (MOSC) 8 commentsAnswered

Hello

I have a serious problem, I have the error ORA-08102: index key not found, obj # 39, file 1, block 280372 (2); object 39 is an index i_obj4 of the table obj $; you can not do an alter index rebuild online, because I have the standard version; and if I do without online; The resource is busy because it belongs to the SYS user.

The probelama that I have is when I want to create something gives error

ex:

SQL> create table test (t number);

create table test (t number)

*

ERROR at line 1:

ORA-00604: error occurred at recursive SQL level 1

ORA-08102: index key not found, obj# 39, file 1, block 280372 (2)

Tagged:

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