Re: ARCHIVELOG and large number of inserts.

From: Jeremiah Wilton <jeremiah_at_wolfenet.com>
Date: Sat, 13 Mar 1999 21:20:09 -0800
Message-ID: <Pine.OSF.4.02.9903132116420.12728-100000@gonzo.wolfenet.com>

On Fri, 12 Mar 1999, Torsten Borchert wrote:
>
> yes: create table .... unrecoverable;
>
> no redo's will be written.

That just suppreses logging for CTAS (create table as select ...) It won't make the table a "no logging" table forever.

--
Jeremiah Wilton http://www.wolfenet.com/~jeremiah

> Yann Doussot wrote:
> >
> > So my question is: is a way to completely disable logging for a
> > table (or tablespace) ? I've read docs carefully and the answers seems
> > to be "no". Any ideas ?
Received on Sat Mar 13 1999 - 23:20:09 CST