ORA-06512: at "SYS.DBMS_AQ_INV", line 1248
Hi
I was getting in the alert log:-
ORA-00600: internal error code, arguments: [13011], [7907], [12679954], [1], [13461738], [0], [], [], [], [], [], []
ORA-01403: no data found
ORA-06512: at "SYS.DBMS_AQ_INV", line 1248
I tried analyze table SYS.SCHEDULER$_EVENT_LOG validate structure cascade;
and got error
ERROR at line 1:
ORA-01499: table/index cross reference failure - see trace file
but when I run analyze table SYS.SCHEDULER$_EVENT_LOG validate structure it was analyzed , suggesting an issue with index?
So I ran
select 'alter index '||owner||'.'||index_name||' rebuild;' from dba_indexes where table_name='SYS.SCHEDULER$_EVENT_LOG';
and got :-