Re: Rollback Segment

Direct load inserts still cause rollback to be generated for index updates.

And there is always a little rollback due to dictionary updates. Presumably you
did have the table declared as NOLOGGING ?

--

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

EnderW wrote in message <8p72pn$aie$1_at_nnrp1.deja.com>...


>direct-load insert ?

>though this seems to be doing rollback activity as well.

>

>INSERT /*+ APPEND */ INTO emp

>   SELECT * FROM t_emp;

>