Home » Server Options » Replication » Materialized view (Oracle 9.2.0.8.0)
Materialized view [message #314761] Thu, 17 April 2008 13:18 Go to next message
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 #314832 is a reply to message #314761] Thu, 17 April 2008 23:57 Go to previous messageGo to next message
gopu_g
Messages: 54
Registered: March 2008
Location: mumbai
Member

premkumarsp1 wrote on Thu, 17 April 2008 13:18
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.
thanks in advance...


what is the time interval given for refreshing the mv's ?
Re: Materialized view [message #314855 is a reply to message #314832] Fri, 18 April 2008 01:16 Go to previous messageGo to next message
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 #314862 is a reply to message #314855] Fri, 18 April 2008 01:26 Go to previous messageGo to next message
gopu_g
Messages: 54
Registered: March 2008
Location: mumbai
Member

Hi,

what are the errors you are getting in the alert log file ?

regards
Gopu
Re: Materialized view [message #314879 is a reply to message #314761] Fri, 18 April 2008 02:17 Go to previous messageGo to next message
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 Go to previous message
gopu_g
Messages: 54
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
Previous Topic: ORA-04030: out of process memory
Next Topic: replication with oracle xe
Goto Forum:
  


Current Time: Fri Dec 09 01:49:59 CST 2016

Total time taken to generate the page: 0.08432 seconds