Re: Snapshot Logs Explanation Needed

Correct.

By the way: A good rule is to always keep the sequence "Table - Snapshot Log - Snapshot", ie. don't break the sequence, for instance by dropping and re-creating the snapshot log. If something happens to the snapshot log you should drop the snapshot, create the snapshot log, then re-create the snapshot.

Mogens

"Norrell, Brian" wrote:

> Been a while since I worked with snapshots, but if I remember correctly,
> each record in a fast refresh snapshot keeps a mapping back to the rowid on
> the master. If you drop and recreate the master table, the mapping is hosed
> and updates/deletes do not propagate to the snapshot.
>
> Brian Norrell
> Manager, MPI Development
> QuadraMed
> 511 E John Carpenter Frwy, Su 500
> Irving, TX 75062
> (972) 831-6600
>
> -----Original Message-----
> Sent: Wednesday, May 30, 2001 5:48 PM
> To: Multiple recipients of list ORACLE-L
>
> 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: Tracy.Rahmlow_at_aexp.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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Norrell, Brian
> INET: BNorrell_at_QuadraMed.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).

--
Venlig hilsen

Mogens Nørgaard

Technical Director
Miracle A/S, Denmark
Web: http://MiracleAS.dk
Mobile: +45 2527 7100


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mogens =?iso-8859-1?Q?N=F8rgaard?=
  INET: mno_at_MiracleAS.dk

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).