Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> What is different between sql*load(direct=y) and insert /+*append */

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

From: David <dhs_69_at_hotmail.com>
Date: 1 Oct 2002 11:44:21 -0700
Message-ID: <7e64a3ea.0210011044.706e0261@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
Received on Tue Oct 01 2002 - 13:44:21 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US