Home » SQL & PL/SQL » SQL & PL/SQL » Materialized view (oracle 10 g)
Materialized view [message #379564] Wed, 07 January 2009 00:59 Go to next message
jayapraksh
Messages: 3
Registered: January 2009
Location: pune
Junior Member

Hi,



There is one Legacy database DB1 and other Oracle Applications Database DB2. I created a Read-Only Materialized View in Legacy Database DB1 which fetches the data from Oracle Apps Database DB2 Tables.

Now my question is,

When there will be a downtime for oracle Applications Database DB2 then will new Materialized View be accessible in Legacy Database DB1?
Regards and Thanks in Advance!!
Jayaprakash.
Re: Materialized view [message #379568 is a reply to message #379564] Wed, 07 January 2009 01:24 Go to previous messageGo to next message
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Yes, it will be queryable, but it cannot be refreshed whilst the source database is down.

Ross Leishman
Re: Materialized view [message #379574 is a reply to message #379568] Wed, 07 January 2009 02:09 Go to previous messageGo to next message
jayapraksh
Messages: 3
Registered: January 2009
Location: pune
Junior Member

The materiliazed view will refresh every day in the morning, so the next day morning if data base is up then is it refresh?
Jayaprakash.

[Updated on: Wed, 07 January 2009 02:13]

Report message to a moderator

Re: Materialized view [message #379578 is a reply to message #379574] Wed, 07 January 2009 02:19 Go to previous message
MarcS
Messages: 312
Registered: March 2007
Location: Antwerp
Senior Member
"Refresh" involves collecting the data from your DB2.
So if database DB2 is not running, no data can be collected.
The refresh will fail, but there is still data in your materialized view on DB1, however the data will be out-of-date.

Can you access your pc's hard-drive when it is not running?
Can you accept phone-calls when your mobile is not switched on?

EDIT: seems you updated your question, now the answer is YES Smile

[Updated on: Wed, 07 January 2009 02:23]

Report message to a moderator

Previous Topic: i want to display the alphabetic letters for the range of salaries by using decode
Next Topic: Help needed regarding collect function
Goto Forum:
  


Current Time: Tue Feb 18 01:39:50 CST 2025