Database Administration (MOSC)

MOSC Banner

SQL> Analyze table SYS.MON_MODS$ validate structure cascade online;

edited Aug 18, 2014 4:10AM in Database Administration (MOSC) 4 commentsAnswered

Hello everyone,

after a disk change my oracle database starts but stops after fifteen minutes.

the source of the problem has been identified. below

the error.

SQL> Analyze table SYS.MON_MODS$ validate structure online;

Table analyzed.

SQL>

SQL> Analyze table SYS.MON_MODS$ validate structure cascade online;

Analyze table SYS.MON_MODS$ validate structure cascade online

*

ERROR at line 1:

ORA-01499: table/index cross reference failure - see trace file.

bellow the error in the trace file

bash-3.00$ tail voucherdb_ora_1456.trc

Hash table buckets = 32768

Longest hash chain = 1

Average hash chain = 7/7 = 1.0

Max compares per lookup = 1

Avg compares per lookup = 39/46 = 0.8

----------------------------------------------

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