Re: Rollback Segments vs direct=true/sqlldr

From: <kvsraju_at_my-dejanews.com>
Date: Thu, 04 Feb 1999 12:14:04 GMT
Message-ID: <79c2u7$brj$1@nnrp1.dejanews.com>

In article <78ar9f$j9v$1_at_nnrp1.dejanews.com>, andrea_johnson_at_wolfe.net wrote:
> Oracle 8.04 solaris
>
> I've had problems before using sqlldr with 'replace' in the ctl file--in that
> my rollback segments weren't able to extend sufficiently. I thought I could
> bypass the rollback segments using direct=true. But apparently the rollback
> segments still kick in with 'replace'.
>
> Is there any way to bypass rollback segments with sqlldr?
>
> Thanks!
>

Hi,
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.
Hope u'r doub't is clarified.
rgds
k.v.s.raju ,INDIA
kvsraju_at_polaris.co.in or
kvsraju_at_usa.net

> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

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