Re: Rollback Segments vs direct=true/sqlldr

What you say OUGHT to be true, however if the replace keyword is used the WHOLE exercise goes into logging mode (latest test version v 7.3.3.5) even if the table was originally empty.

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

P.S.

    Descartes to his serant - 'Good God, man, are you mad or am I ?'     Servant to Descartes - 'Sir, surely you would not employ a madman'.

>"REPLACE" isn't really related directly to whether you use direct loader
>or not...
>
>REPLACE is equivalent to "delete from table;" at the start of your run -
>hence the need for large rollback segments... The TRUNCATE keyword
>issues a "truncate table;" which is faster and won't need the rollback
>space...
>
>HTH
>--
>==============================================
>Connor McDonald
>BHP Information Technology
>Perth, Western Australia
>"The difference between me and a madman is that I am not mad"
> - Salvador Dali
Received on Sun Jan 24 1999 - 03:32:11 CST