Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: turn off redo log?

Re: turn off redo log?

From: Paul Brewer <paulb_at_pbrewer.demon.co.uk>
Date: 1997/05/21
Message-ID: <9pB0oBAtO1gzEwhE@pbrewer.demon.co.uk>#1/1

In article <3380AF0B.41C6_at_garland.dnr.state.sc.us>, edwards_at_garland.dnr. state.sc.us writes
>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.
>

If you're trying to *load* data from the operating system, you can use SQL*Loader direct path with the unrecoverable option. This is very fast and doesn't write to the redo logs, but the data must be clean or it's a waste of time trying.
HTH Paul

-- 
Paul Brewer
Received on Wed May 21 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US