Re: Optimizing snapshot creation

We did it for "fast refresh" snapshot. Our problem was the very first update ( to copy a lot of data through very bad comm. link ) - it was interrupted each time and we had to restart the job. Our 'cheating' solved that problem.
I'm not sure if your 'cheat' is better than mine, but probably you must try it - if it works - then it's fine.

P.S. Think positive - such an expensive product does not limit your

     need to improvization.

 Michael.

In article <383eed04.97870010_at_news.earthlink.net>,   andreyNSPAM_at_bookexchange.net (NetComrade) wrote:
> I've read about anther cheat too (was just thinking if I can avoid
> 'cheating' with a product that costs so much)
>
> Create a new user on the MASTER db, with all the needed DB_LINKS etc.
> (also tnsnames.ora will probobly have to be the same as with local
> db). Create a snapshot in a new schema, imp/exp to the local DB.
>
> Yours sounds like a quicker solution, but I think the one I read about
> takes care of the fast refresh (we are a 24/7 environment).
>
> On Fri, 26 Nov 1999 15:00:26 GMT, michael_bialik_at_my-deja.com wrote:
>
> >Hi.
> >
> > We had some problems with snapshots ( were unable to execute it for
a
> > first time - it also took forever ), so we 'cheated' :
> > 1. Created a snapshot with 0 rows ( put 'WHERE 1 = 2' ).
> > 2. Exported the table and Imported it as snapshot.
> > 3. Altered the snapshot ( removed 1 = 2 ).
> >
> > Worked just fine.
> >
> > HTH. Michael.
> >
> >
> >In article <383da3cd.13577804_at_news.earthlink.net>,
> > andreyNSPAM_at_bookexchange.net (NetComrade) wrote:
> >> Hi,
> >> I am creating a SNAPSHOT on 8i from 7, and it just takes forever
(the
> >> table has aroudn 300K rows), is there are a way to speed it up? I
> >> haven't found anything on Metalink or deja.
> >>
> >> Thanx
> >> ---------------
> >> Andrey Dmitriev eFax: (978) 383-5892 Daytime: (917) 373-5417
> >> AOL: NetComrade ICQ: 11340726 remove NSPAM to email
> >>
> >>
> >
> >
> >Sent via Deja.com http://www.deja.com/
> >Before you buy.
>
> ---------------
> Andrey Dmitriev eFax: (978) 383-5892 Daytime: (917) 373-5417
> AOL: NetComrade ICQ: 11340726 remove NSPAM to email
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Nov 27 1999 - 00:52:40 CST