| Materialized view [message #314761] |
Thu, 17 April 2008 13:18  |
premkumarsp1
Messages: 3
Registered: April 2008 |
Junior Member |
|
|
Hi all,
I created materialized view in Database B. The master table is in Database A. If i shutdown the database B and bring it up again, the next refresh time in dba_jobs tablein database A is coming as 01-jan-00. It is not getting refreshed automatically. The job_queue_process is 10. wat could be the reason, for the refresh failure. Can someone help me out..
thanks in advance...
|
|
|
|
| Re: Materialized view [message #314855 is a reply to message #314832 ] |
Fri, 18 April 2008 01:16  |
premkumarsp1
Messages: 3
Registered: April 2008 |
Junior Member |
|
|
|
The refresh time given is 1 minute. It is declared in the create materializED view command.
|
|
|
|
| Re: Materialized view [message #314879 is a reply to message #314761 ] |
Fri, 18 April 2008 02:17 |
premkumarsp1
Messages: 3
Registered: April 2008 |
Junior Member |
|
|
In alert log i could not find any error. The job has been broken.
when i gave the command to run the broken job, it started to work.
I want to know why the job is getting broken after i shutdown the database?
Thanks for your reply gobu...
|
|
|
| Re: Materialized view [message #314881 is a reply to message #314879 ] |
Fri, 18 April 2008 02:23 |
gopu_g
Messages: 50
Registered: March 2008
Location: mumbai |
Member |
|
|
hi,
the refresh time you given is one minute.
then if you shutdown the database, how it will work.Most probably the job will breake.In most cases we can find the error in the alert log.
Gopu
|
|
|
]
Members
Search
Help
Register
Login
Home
