Hi Anita,
I'm not sure if you are the original poster but ....
There is a way to force a view into fast refresh mode
after you have restructured the snapshot logs
WARNING: This is unsupported by Oracle and involves messing
with the data dictionary.
I once had to create a 4GB snapshot over an ISDN line
This was done by creating the snapshot locally, exporting,
ftp, import and then:
In DBA_SNAPSHOTS (I believe) I compared the entry in the local
database to the remote. One field was different in my case. A simple
update to the data dictionary enabled the FAST REFRESH to take place.
THIS IS DANGEROUS STUFF :)
Dave
--
Dave Morgan
DBA, Cybersurf
Office: 403 777 2000 ext 284
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Dave Morgan
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).
