OraFAQ Forum: Replication » Materialized view

Home » Server Options » Replication » Materialized view (Oracle 9.2.0.8.0)

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

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

Report message to a moderator

Re: Materialized view [message #314832 is a reply to message #314761]

Thu, 17 April 2008 23:57

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 ?

Report message to a moderator

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.

Report message to a moderator

Re: Materialized view [message #314862 is a reply to message #314855]

Fri, 18 April 2008 01:26

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

Report message to a moderator

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

Report message to a moderator

Re: Materialized view [message #314881 is a reply to message #314879]

Fri, 18 April 2008 02:23

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

Report message to a moderator

Previous Topic:	ORA-04030: out of process memory
Next Topic:	replication with oracle xe

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 11 22:11:27 CDT 2026