|
|
|
Re: Materialized view [message #379578 is a reply to message #379574] |
Wed, 07 January 2009 02:19  |
 |
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
[Updated on: Wed, 07 January 2009 02:23] Report message to a moderator
|
|
|