Have you checked the outcome of the job? What does it say?
i checked the output ,there is no change in the materialized view data.how can i solve this issue ?
thanks & rregards.
We don't know what your procedure mv_refresh_job is doing.
Why you don't simply call dbms_mview.refresh directly ?
BEGIN DBMS_SCHEDULER.CREATE_JOB ( JOB_NAME => 't1_MV_REFRESH', JOB_TYPE => 'PLSQL_BLOCK', JOB_ACTION => 'BEGIN DBMS_MVIEW.REFRESH(''T1MV'', ''F''); END;', START_DATE => SYSTIMESTAMP, REPEAT_INTERVAL => 'freq=minutely; bysecond=0;', END_DATE => NULL, ENABLED => TRUE, COMMENTS => 'Refreshes Materialized Views on a Scheduled Basis'); END;
or you can use refresh clause when creating MV.
When you call dbms_mview.refresh('T1MV','F'); from SQL*Plus what's the result ?