OraFAQ Forum: Server Administration » Materialized View Issue

Home » RDBMS Server » Server Administration » Materialized View Issue (Oracle RDBMS, 11.3.2.0, RHEL6)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

Re: Materialized View Issue [message #589179 is a reply to message #589178]

Wed, 03 July 2013 03:43

John Watson
Messages: 8978
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.

Report message to a moderator

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...

Report message to a moderator

Re: Materialized View Issue [message #589199 is a reply to message #589198]

Wed, 03 July 2013 05:10

John Watson
Messages: 8978
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.

Report message to a moderator

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

Report message to a moderator

Re: Materialized View Issue [message #589205 is a reply to message #589201]

Wed, 03 July 2013 05:30

cookiemonster
Messages: 13967
Registered: September 2008
Location: Rainy Manchester

Senior Member

Then you need to get the DBAs to get the information for you.

Report message to a moderator

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.

Report message to a moderator

Previous Topic:	RMAN Restore Failure
Next Topic:	Synchronize data between two database.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jun 10 02:33:56 CDT 2025