| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE:Materialized views across a db l
HI JOHN, What exactly the error.Please be more specific.Was the MV created. Or after creation of MV after some interval (The interval specified while creating MV) you didn't see the refreshed data.I suppose that must be so..
Check Job_queue_processes,Job_queue_interval parameters in your init.ora files of both DBS.Becuase these parameters create additionnal processes(SNP-processes) which will be responsible for your snapshot refresh.So please set these parameters
And check any event parameter set in your init.ora file.If it is set then try to comment and see.This will be the case when above doesn't work
Cheers
Ganti
The contents of this e-mail are confidential to the ordinary user of the e-mail address to which it was addressed and may also be privileged. If you are not the addressee of this e-mail you should not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you have received this e-mail in error please notify us by telephone or e-mail the sender by replying to this message, and then delete this e-mail and other copies of it from your computer system. Thank you
We reserve the right to monitor all e-mail communications through
our network
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: GANTI.SIVA_at_ponl.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Mar 05 2001 - 04:19:54 CST
 |
 |