Re: Rollback Segments vs direct=true/sqlldr

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 22 Jan 1999 22:56:40 -0000
Message-ID: <917045756.1037.0.nnrp-11.9e984b29@news.demon.co.uk>

Try using truncate instead of replace. It's an odd quirk I have noticed on 7.3.3.5 as well.

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

andrea_johnson_at_wolfe.net wrote in message <78ar9f$j9v$1_at_nnrp1.dejanews.com>...
>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!
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Fri Jan 22 1999 - 16:56:40 CST