| Oracle Jobs failed [message #378565] |
Tue, 30 December 2008 23:54  |
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 #378616 is a reply to message #378600] |
Wed, 31 December 2008 02:06  |
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.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
