Re: An Oracle newbie question

From: Peter H. Larsen <plarsen.nospam_at_dc.dynares.com>
Date: Thu, 09 Jul 1998 08:26:51 -0400
Message-ID: <35A4B70B.BF48C448@dc.dynares.com>

Hi Jack,
Sorry, but that doesn't do jack (hehe ... sorry, couldn't help it) about the transaction mode. Oracle ALWAYS work in transaction mode, but using specific tools you have ways of bypassing some of it (redo log files). Even without archive Oracle uses Redo logs.

The UNRECOVER option on CREATE INDEX and in SQL Loader bypasses redo log generation. Use it with care, as you'll lose the data on recovery - but that's what the question was about ... he didn't care about recovery. And sometimes you don't :)

Peter H. Larsen

P.S. Sorry it is meant as no offence to you ... just trying to get myself going here on an early Thursday morning ....

Jack Ploeg wrote:
>
> Try:
> ALTER SYSTEM ARCHIVE LOG STOP
>
> Jack

Peter H. Larsen, Oracle and Applications specialist Dynamic Resources Inc, Alexandria
Email: plarsen_at_dc.dynares.com
(please remove the nospam from the header when replying to this email)

The above views are my own and does not reflect the views of my employer. Received on Thu Jul 09 1998 - 07:26:51 CDT