Re: Optimizing snapshot creation

From: <michael_bialik_at_my-deja.com>
Date: Fri, 26 Nov 1999 15:00:26 GMT
Message-ID: <81m7a9$eg6$1@nnrp1.deja.com>

Hi.

We had some problems with snapshots ( were unable to execute it for a first time - it also took forever ), so we 'cheated' :

Created a snapshot with 0 rows ( put 'WHERE 1 = 2' ).
Exported the table and Imported it as snapshot.
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. Received on Fri Nov 26 1999 - 09:00:26 CST