Home » RDBMS Server » Server Administration » Oracle Jobs failed (Oracle 10g , Rel 2 ,Linux AS4)
Oracle Jobs failed [message #378565] Tue, 30 December 2008 23:54 Go to next message
rsreddy28
Messages: 295
Registered: May 2007
Senior Member
Hello All,

We are running Pl/Sql Jobs daily . But suddenly today we got an error stating with error Ora - 12005 . I've seen even in the metalink , but the only solution to that is :

ORA-12005: may not schedule automatic refresh for times in the past
Cause: An attempt was made to schedule an automated materialized view refresh for a time in the past.
Action: Choose a time in the future instead.


What can be done in this regard.

kindly help us out.

Regards,
Raj

Re: Oracle Jobs failed [message #378600 is a reply to message #378565] Wed, 31 December 2008 01:23 Go to previous messageGo to next message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use "alter materialized view" to modify the "start with" and "next" refresh times.

Regards
Michel
Re: Oracle Jobs failed [message #378616 is a reply to message #378600] Wed, 31 December 2008 02:06 Go to previous messageGo to next message
rsreddy28
Messages: 295
Registered: May 2007
Senior Member
Mike,

Its not a materilised view. Rather its a pl/sql job of Perfstat schema which takes the snapshot of the database every hour.

How can we work on this.

Re: Oracle Jobs failed [message #378635 is a reply to message #378616] Wed, 31 December 2008 03:09 Go to previous messageGo to next message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use dbms_job or related to modify the scheduling.

Regards
Michel
Re: Oracle Jobs failed [message #379189 is a reply to message #378635] Mon, 05 January 2009 05:27 Go to previous message
rsreddy28
Messages: 295
Registered: May 2007
Senior Member
Thank you , Mike .
Previous Topic: parallel query error
Next Topic: user/dba_segments refresh issue
Goto Forum:
  


Current Time: Wed Dec 07 08:26:07 CST 2016

Total time taken to generate the page: 0.08365 seconds