Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: turn off redo log?
[This followup was posted to comp.databases.oracle.misc and a copy was sent to the cited author.]
In article <3380AF0B.41C6_at_garland.dnr.state.sc.us>,
edwards_at_garland.dnr.state.sc.us says...
> 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.
SVRMGR> ALTER DATABASE NOARCHIVELOG ; Don't forget to shutdown the database and get a good backup after you load the data, and of course, turn archive logging back on.
--rick Received on Tue May 20 1997 - 00:00:00 CDT