Re: turn off redo log?

From: <edwards_at_garland.dnr.state.sc.us>
Date: 1997/05/20
Message-ID: <3382054C.41C6@garland.dnr.state.sc.us>#1/1

Richard Hoffbeck wrote:

> 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.

Thanks for the suggestion.
I was hoping I could set logging off for just one transaction rather than shutting down the entire instance. Like the way you can set the rollback segment for your transaction? 'set transaction use rollback segment rb01'

is there anything like
'set transaction NOARCHIVELOG' ??? Received on Tue May 20 1997 - 00:00:00 CDT