Re: turn off redo log?

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

Do a "alter database noarchivelog" AFTER shutting down and restarting with your init.ora with log_archive_start=true (and valid log_archive format and dest parms).

If you only alter the database without shutting down, you'll hang the database at next archive log switch since you're telling it to not switch without archiving but you haven't told it where or whether to archive.

-- 
Gary Melhaff
Senior Database Analyst
Weyerhauser Corporation