Re: Using Snapshots

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Sun, 10 Oct 1999 13:59:22 +0800
Message-ID: <38002B3A.1EAF@yahoo.com>

Rod Boyle wrote:
>
> Rod Boyle's question:
> >
> > > My question is how do I fix this the snapshots to update only the rows
> that
> > > need to updated?
> > >
>
> Nicolas Bronke <newsgroup_at_trinity.de> wrote in message
> news:37ff8e51_at_news2.prserv.net...
> > Did you create the snapshot with the option fast ?
> > But not every select of a table can be used to create a snapshot with the
> > fast option.
> > Refer to the sql-reference manual page 4-230ff
> >
> > Regards
> > Nicolas Bronke
> >
> >
>
> Rod Boyle's Response:
>
> Nicolas,
>
> I am not certain that the snapshot was created with the fast, complete,
> force or the default (force). Once I get back to work I will look to see
> how that it was created.
>
> However, I would further need to find out if the Master Database has setup
> SNAPSHOT_LOGS, correct?
>
> Thanks,
>
> Rod Boyle
> boyler_at_mindspring.com

Look for a table MLOG$_tname on the master...

Also have a strong think about upgrading to Oracle8 - the snapshot logs are implemented with an internal trigger not a standard database triggers which makes snapshot logs hum along faster...

HTH
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Sun Oct 10 1999 - 00:59:22 CDT