materialized view
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: materialized view

  1. #1
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681

    materialized view

    Hi friends,

    What is the difference of the 2 commands?

    1.> create materialized view oe.emp
    as select * from oe.emp@ora1.world;

    2.> create materialized view oe.emp refresh fast
    as select * from oe.emp@ora1.world;

    What type of refresh does #1 use by default?
    is it REFRESH SLOW?

    thanks a lot
    Behind The Success And Failure Of A Man Is A Woman

  2. #2
    Join Date
    Oct 2006
    Posts
    11

    No. It is REFRESH FORCE

    >"What type of refresh does #1 use by default? is it REFRESH SLOW?"

    No. It is REFRESH FORCE, which will issue a REFRESH FAST if possible (MATERIALIZED VIEW LOG exists, among others) or REFRESH COMPLETE.

    HTH.

    Cheers.

    Carlos.

  3. #3
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    Thanks dear...

    I got confused about this command also.

    > create materialized view oe.emp
    REFRESH FAST START WITH SYSDATE NEXT SYSDATE + 1/24
    as select * from oe.emp@ora1.world;

    Is this a correct syntax? Does it refresh my view every hour
    for eternity? or just the next 1 hr one time only?

    ...or do i need to run this command>

    DBMS_DEFER_SYS.SCHEDULE_PUSH (
    destination => 'ora1.world',
    interval => 'SYSDATE + (1/24)', -- you set the time interval here
    next_date => SYSDATE,
    parallelism => 4,
    execution_seconds => 0,
    delay_seconds => 55);
    END;
    /

    Thanks a lot
    Last edited by yxez; 12-19-2006 at 10:14 PM.
    Behind The Success And Failure Of A Man Is A Woman

  4. #4
    Join Date
    Oct 2006
    Posts
    11

    more on MV's...

    >>"Is this a correct syntax? Does it refresh my view every hour
    for eternity? or just the next 1 hr one time only?"

    It is correct... as long as you have a materialized view log for the master table.

    It will refresh the MW one hour after it finishes refreshing each time.

    HTH.

    Cheers.

    Carlos.

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