Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Rollback Segments vs direct=true/sqlldr

Re: Rollback Segments vs direct=true/sqlldr

From: <arc_at_my-dejanews.com>
Date: Thu, 04 Feb 1999 17:26:54 GMT
Message-ID: <79cl8g$s58$1@nnrp1.dejanews.com>


In article <79c2u7$brj$1_at_nnrp1.dejanews.com>, kvsraju_at_my-dejanews.com wrote:

> There is no option to by pass the rollback segments when loading data using
> sql*loader.The DIRECT option don't do that. That option is only to bypass
> evaluation buffers.

The UNRECOVERABLE option (direct path only) is described as :

  An UNRECOVERABLE load does not record loaded data in the redo log file.

(Oracle 7.3 Server Utilities manual)

Surely this equates with 'bypassing rollback segments'...

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Feb 04 1999 - 11:26:54 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US