Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: turn off redo log?
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 BrewerReceived on Wed May 21 1997 - 00:00:00 CDT