SQL> Analyze table SYS.MON_MODS$ validate structure cascade online;
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
----------------------------------------------