Re: snapshots

in 8 there is an option for tables NOLOGGING. you can try
ALTER TABLE SNAP$_name NOLOGGING;

On Tue, 23 Nov 1999 14:25:56 +0100, Juan Gonzalez <Juan.gonzalez_at_impiva.m400.gva.es> wrote:

>I have a problem vith snapsoths and Archivelog data
>In ARCHIVELOG mode, It īs possible to refresh completely a complex
>snapshot without producing archivelog data ? (something like an
>unrecoverable refresh)
>The version of the database server is Oracle 7.3.4
>Can I do this in a greater version?
>
>Thanks
>

Andrey Dmitriev	 eFax: (978) 383-5892  Daytime: (917) 373-5417
AOL: NetComrade	 ICQ: 11340726 remove NSPAM to email