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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
