Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Location
    Manchester, UK
    Posts
    15

    Question Unanswered: Refreshing snapshots in refresh groups

    Hi all,

    Just a quick query about refresh groups - I've looked up the syntax to create a refresh group, add and subtract snapshots to it, etc and I understand all that. However, what I don't know is whether I can refresh an individual snapshot when it is part of a group or whether I have to refresh the whole group.

    Regards
    Malteser

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    You can refresh a single snapshot within a refresh group ...

    ----- Fast Refresh -----
    BEGIN
    dbms_snapshot.refresh(
    list=> 'OWNER.TABLENAME,
    method=> 'F',
    rollback_seg=> 'RBS_ACCOUNTING_DETAIL',
    push_deferred_rpc=> TRUE,
    refresh_after_errors=> TRUE);
    END;
    /

    ----- Complete Refresh -----
    BEGIN
    dbms_snapshot.refresh(
    list=> 'OWNER.TABLENAME',
    method=> 'C',
    rollback_seg=> 'RBS_ACCOUNTING_DETAIL',
    push_deferred_rpc=> TRUE,
    refresh_after_errors=> TRUE);
    END;
    /


    HTH
    Gregg

Posting Permissions

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