 Materialized View Issue [message #589178] |
Wed, 03 July 2013 03:24  |
saleh_binmasood
Messages: 30
Registered: October 2009
|
Member |
|
|
Dear Admins,
Basically i am not a DBA, please excuse me for simple questions.
I created a materialized view successfully, given in below query.
But to my surprise it does not refreshes automatically.
Create Materialized view 3DTest
refresh fast start with (sysdate) next (sysdate+1/24)
AS SELECT * FROM ABC.3D_VW@DB1;
Later i viewed the details in SQL Developer, i found that though i created with specified time(1 Hour) to refresh it automatically, it is showing, refresh mode as ON DEMAND...
Please help me out to resolve this issue...
Thanks
|
|
|
|
| Re: Materialized View Issue [message #589179 is a reply to message #589178] |
Wed, 03 July 2013 03:43  |
John Watson
Messages: 8964
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
ON DEMAND is correct. If it is not being refreshed, you need to check whether the job is running. Look at dba_jobs to see if it is failing: if so, there will be errors in the alert log and trace files generated by the Jnnn process that tried to do it.
|
|
|
|
| Re: Materialized View Issue [message #589198 is a reply to message #589179] |
Wed, 03 July 2013 05:04 |
saleh_binmasood
Messages: 30
Registered: October 2009
|
Member |
|
|
Thanks John for prompt input.
Basically i believe it does not run the refresh, because i can view details showing in SQL-DEV
REFRESH OPTIONS:
WHEN: SPECIFY
METHOD: COMPLETE
TYPE:
START ON: 03-JUL-2013 10:53:00
NEXT: 03-JUL-2013 10:55:02
What i understand from the above detail, it is never set to run refresh...
|
|
|
|
|
|
| Re: Materialized View Issue [message #589201 is a reply to message #589199] |
Wed, 03 July 2013 05:13 |
saleh_binmasood
Messages: 30
Registered: October 2009
|
Member |
|
|
John, pls Do not get angry ...
I forgot to post it,
I do not have access to dba_ tables and logs, i am working on front end. The database support do not allow us to create MVIEWs officially. I cannot ask them to give me access to dba_ tables or logs.
Hope you understand
|
|
|
|
|
|
| Re: Materialized View Issue [message #589211 is a reply to message #589178] |
Wed, 03 July 2013 05:51 |
nukalaaru
Messages: 4
Registered: July 2010
Location: Banglore
|
Junior Member |
|
|
We have seen similar problem in our environment and observed Job queue process value is zero. After changing the value to 10, the job is refreshing automatically.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
