Tracy,
You may know that there were no modifications to the
master table made from the time the snapshot log was
dropped until it was recreated, but Oracle can't take
that chance, otherwise data could get out of sync.
That's why you have to either recreate your snapshot
or do a complete refresh if the snapshot log is
recreated.
To avoid recreating the snapshots I would ask why you
need to reorg your master tables (i.e. what do you
hope to accomplish by this)? If you're doing it for
defragmentation reasons, I suggest you check out the
excellent white paper "How to stop defragmenting and
start living..." to see if this is really necessary.
http://www.vampired.net/articles/files/stopfrag.zip
HTH,
-- Anita
--- Tracy Rahmlow <[EMAIL PROTECTED]> wrote:
> I would like to reorg many tables which have
> snapshots associated with them. I
> understand that if the master table is dropped the
> snapshot log is also
> dropped. When a log is dropped, oracle states that
> you need to do a complete
> refresh of the affected snapshot. My question is
> why? If you do not allow
> users to access the database with the master table,
> then you should not have
> any transactions that would be lost. Why can't you
> create a new log and
> continue to do a fast refresh? I am trying to
> avoid having to recreate all
> the snapshots due to the size and number that we
> have. Any thoughts? Thanks
>
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Tracy Rahmlow
> 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).
__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: A. Bardeen
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).
