-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|