Error in snapshot refreshing
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Error in snapshot refreshing

  1. #1
    Join Date
    Sep 2000
    Posts
    78

    Arrow

    Hi,

    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], [4294967295],
    [301301848], [353196844], [], [], [], []
    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?

    Thanx!

  2. #2
    Join Date
    Apr 2000
    Location
    roma
    Posts
    131
    are you working via db-link?
    if so check the connection.

  3. #3
    Join Date
    Sep 2000
    Posts
    78

    Cool


    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 :(

  4. #4
    Join Date
    Aug 2000
    Posts
    87
    Hi,

    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.

    Cheers,
    Vinod Kumar.

  5. #5
    Join Date
    Sep 2000
    Posts
    78
    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...

  6. #6
    Join Date
    May 2000
    Location
    Alex, Egypt
    Posts
    41
    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.
    Amir Magdy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width