Home » Server Options » Streams & AQ » job for refreshing materialized view is failed
job for refreshing materialized view is failed [message #352014] Sun, 05 October 2008 03:11
khosravi
Messages: 68
Registered: April 2006
Member
Hello to all

I have created a read only materialized view and i have created a
stored procedure that calls DBMS_MVIEW.REFRESH for refreshing the
materialized view by this script

CREATE MATERIALIZED VIEW "REZA"."T1_MV2"
REFRESH FAST WITH PRIMARY KEY
AS SELECT "T1"."ID" "ID","T1"."NAME" "NAME" FROM "REZA"."T1"@TEHRAN.COM "T1";

create or replace procedure refresh_mv
as
begin

DBMS_MVIEW.REFRESH (list=>'reza.t1_mv2',push_deferred_rpc=>false,method=>'f');

end;

and i have created a job for calling refresh_mv frequently by this script

DBMS_SCHEDULER.CREATE_JOB (
job_name => 'MV_JOB',
job_type => 'STORED_PROCEDURE',
job_action => 'reza.refresh_mv',
start_date => SYSTIMESTAMP,
repeat_interval => 'FREQ=SECONDLY;INTERVAL=90',
end_date => null
);

when i run this job by DBMS_SCHEDULER.RUN_JOB all thing is right and the materialized view will be update
and STATUS filed in ALL_SCHEDULER_JOB_LOG is SUCCEEDED for that execution
and it's completion duration is very short (+000000000 00:00:00.141000)

but when the job execute in its time (my mean is every 90 second) that will be failed and materialized view don't update
and STATUS filed in ALL_SCHEDULER_JOB_LOG is FAILED for this job

do you know what is wrong?

thanks
Previous Topic: Stream_pool_size parameter setting on 0racle 10g releae 2
Next Topic: Deqeueing is not progressing after a RAC instance fails
Goto Forum:
  


Current Time: Sat Oct 25 09:30:15 CDT 2014

Total time taken to generate the page: 0.10451 seconds