Re: What is different between sql*load(direct=y) and insert /+*append */

insert /*+ append */ does normal updates to index blocks, which typically generates a lot of undo (rollback).

Direct load has the option to postpone
the index updates, builds a small index
on the loaded data, then merge it with
the existing index without generating
undo (rollback)..

--
Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

Next Seminar dates:
(see http://www.jlcomp.demon.co.uk/seminar.html )

____USA__________November 7/9 (MI), 19/21 (TX)
____England______November 12/14

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html








David wrote in message <7e64a3ea.0210011044.706e0261_at_posting.google.com>...


>Hi,

>

>We used to use sql*load with direct=y option to load

>our clickstream data,in order to get better performance,

>we recently use " insert /+* append */ "

>approach, but we got "rollback segment too small" error.

>

>how sql*load never got this problem ? what is the different

>between two approachs in oracle?

>

>Thanks

>David