Refresh MVs
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 1 of 1

Thread: Refresh MVs

  1. #1
    Join Date
    Feb 2007
    Posts
    212

    Refresh MVs

    Hi All,

    I'm confused which of the 3 programs refreshes my materialized view
    now(sysdate) and onwards and so on and so forth, every 10 seconds .
    These are all outputs of OEM.

    1.)
    BEGIN
    DBMS_DEFER_SYS.SCHEDULE_PUSH(
    destination => 'ORCL2.WORLD',
    interval => '/*10:Secs*/ sysdate + 10/(60*60*24)',
    next_date => SYSDATE,
    stop_on_error => FALSE,
    delay_seconds => 0,
    parallelism => 0);
    END;
    /

    2.)
    BEGIN
    DBMS_REFRESH.MAKE(
    name => '"MVADMIN"."GROUP1"',
    list => '',
    next_date => SYSDATE,
    interval => '/*10:Secs*/ sysdate + 10/(60*60*24)',
    implicit_destroy => TRUE,
    lax => FALSE,
    job => 0,
    rollback_seg => NULL,
    push_deferred_rpc => TRUE,
    refresh_after_errors => TRUE,
    purge_option => NULL,
    parallelism => NULL,
    heap_size => NULL);
    END;
    /

    3.)
    CREATE MATERIALIZED VIEW "SCOTT"."TEST_VIEW"
    TABLESPACE "USERS"
    BUILD IMMEDIATE
    USING INDEX
    TABLESPACE "USERS"
    REFRESH FAST
    START WITH to_date('02-Apr-2007 06:41:15 AM','dd-Mon-yyyy HH:MI:SS AM')
    NEXT sysdate + 10/86400
    AS
    select * from SCOTT.test@orcl2.world
    /
    Last edited by jennifer2007; 05-15-2007 at 04:39 AM.

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