Materialized View Refresh Problem
My Database is oracle9.2.0
I am synchornize data by using materialized view
1. When Creating materialized view ->
DEFINE START_TIME = "TRUNC(sysdate) + 12/24";
DEFINE NEXT_TIME = "TRUNC(sysdate) + 13/24";
--> My Purpose is to run the refresh every 1PM
CREATE materialized view AR_CON_OPTION_DTL
PCTUSED 40
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 10M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
TABLESPACE TS_ArchvMV
LOGGING
NOCACHE
NOPARALLEL
refresh FAST
START WITH &&START_TIME
NEXT &&NEXT_TIME
WITH PRIMARY KEY
USING DEFAULT ROLLBACK SEGMENT
AS
SELECT * FROM AR_CON_OPTION_DTL@FromRPTtoLive;
2. I can use manual refresh to get the data-->
DBMS_MVIEW.refresh('AR_CON_OPTION_DTL', 'F');
3. I notice in DBA_JOBS ,
the what columns indicate :
dbms_refresh.refresh('"TNTRPT"."AR_CON_OPTION_DTL"');
( using different refresh mechanism ?)
Broken column is 'N' and Failure is a number ( 4 or 5 , seems failed )
Interval is "TRUNC(sysdate) + 13/24 "
So I keep waiting but the materialized view is not refresh !
What is the problem ?