|
-
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 ?
1. www.dbasupport.com
2. www.dbforums.com
3. www.itpub.net
4. www.csdn.net
5. www.umlchina.com
6. www.tek-tips.com
7. www.cnforyou.com
8. fm365.federal.com.cn
9. www.programmersheaven.com
10.http://msdn.microsoft.com/library/default.asp
[email protected]
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
|