Re: turn off redo log?

From: Mark Rosenbaum <mjr_at_netcom.com>
Date: 1997/05/23
Message-ID: <mjrEAMvyE.ItG@netcom.com>#1/1

In article <3380AF0B.41C6_at_garland.dnr.state.sc.us>, <edwards_at_garland.dnr.state.sc.us> wrote:
>how do you turn off redo log writing?
>
>I am trying to load some massive data but the redo logs
>fill up disk space and my session halts.
>
>
>Steve Edwards
>SC dept of Natural Resources

Steve,

Rather than turn off logging (not a good idea) why not bypass the logs when loading. If you are loading from flat files try the sqlload with direct=y. If you are creating tables from tables try the unrecoverable option in Oracle 7.2 and later.

Hope this helps

mjr Received on Fri May 23 1997 - 00:00:00 CDT