I want to refresh a snapshot, but I get the following error message:
SQL> exec dbms_mview.refresh('FLEUR_STATS.ALL_STATS','C','RB1');
BEGIN dbms_mview.refresh('FLEUR_STATS.ALL_STATS','C','RB1'); END;
ERROR at line 1:
ORA-12008: error in snapshot refresh path
ORA-00600: internal error code, arguments: [kdiins0:not in s], ,
, , , , , 
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 587
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 644
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 624
ORA-06512: at line 1
When I set it up to refresh automatically it also doesn't work and in the alert log there is only a message that this snapshot was not refreshed.
What might be the problem?
are you working via db-link?
if so check the connection.
No, I am not using db links, it is all on the same DB and machine...
Maybe it is some bug in Oracle..?!?!?
I donno what to do, how to refresh this materialized view :(
Some problem is preventing the snapshot from reading the view on the Master table.A Number of events could cause this problem,among them the following
--The Master table no longer Exists.
--A column was added to the Master table and the view was not altered.
--The master is at a remote site and inaccessible.
Action:The most likely solution is re-create the snapshot.
I recreated the materialized view several times since that, at first it is refreshing ok by using the dbms_mview.refresh proc. but after a while it gives the error mentioned in my first message....Maybe the problem lies in the materialized view logs on the master tables..maybe i should drop them and only use complete refresh...
the error ora-00600 is an internal oracle error, which means an oracle bug.
Whenver you face it, all you can do is to call oracle support, prepare also the trace file generated at the server because they will need it also.
although they will not be able to do anything, only they will tell you to migrate to the next version, or they will send you a patch, in the best cases they will recommend a work around.
Click Here to Expand Forum to Full Width