Home » RDBMS Server » Server Administration » Materialized View Issue (Oracle RDBMS, 11.3.2.0, RHEL6)
icon5.gif  Materialized View Issue [message #589178] Wed, 03 July 2013 03:24 Go to next message
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 Go to previous messageGo to next message
John Watson
Messages: 4793
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 Go to previous messageGo to next message
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 #589199 is a reply to message #589198] Wed, 03 July 2013 05:10 Go to previous messageGo to next message
John Watson
Messages: 4793
Registered: January 2010
Location: Global Village
Senior Member
You haven't bothered to follow my suggestion, have you?
Perhaps someone else will try to assist.
Goodbye.
Re: Materialized View Issue [message #589201 is a reply to message #589199] Wed, 03 July 2013 05:13 Go to previous messageGo to next message
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 #589205 is a reply to message #589201] Wed, 03 July 2013 05:30 Go to previous messageGo to next message
cookiemonster
Messages: 11177
Registered: September 2008
Location: Rainy Manchester
Senior Member
Then you need to get the DBAs to get the information for you.
Re: Materialized View Issue [message #589211 is a reply to message #589178] Wed, 03 July 2013 05:51 Go to previous message
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.
Previous Topic: RMAN Restore Failure
Next Topic: Synchronize data between two database.
Goto Forum:
  


Current Time: Sun Nov 23 11:37:17 CST 2014

Total time taken to generate the page: 0.08725 seconds