| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Which is faster??
As far as I remember direct load allows to load data into indexed table - it "disables" indexes for the loading time and builds the indexes once, after the load completes. Also it prepares binary array corresponding to the table layout and writes directly to the file. Conventional load basically creates an insert statement for each row of data to be loaded and executes it. It also modifies indexes after each record has been loaded. It makes big difference in time, of course depending on the volume
Witold
On 26 Mar 2001, at 7:31, Martin Kendall wrote:
> I know that Direct Path of sqlldr does not allow Indexes
> so what is the comparative performance of this suggestion if
> the given Table is indexed ?
>
> Martin
>
> -----Original Message-----
> Sent: 23 March 2001 09:05
> To: Multiple recipients of list ORACLE-L
>
>
> If you're on 8.0 or higher, try
>
> insert /*+ APPEND */
> into table
> select * from other_table;
>
> where "table" is defined as nologging. Then you won't
> hit either redo logs or rollback segments..Its the
> equivalent of a sqlldr direct load
>
> hth
> connor
>
> --- CC Harvest <ccharvest_at_yahoo.com> wrote: > I have
> the following scripts:
> >
> > insert into table
> > select * from table2
> > ;
> >
> > So if use the about bulk statement in my
> > application, and the table2 is big, say 10
> > million records, my concern is that it's
> > going to fail because of the possible rollback
> > segments failure. So then I have to use PL/SQL
> > to create a cursor and commit every 50000 records.
> > What's the disadvantage of this?Will it be much
> > slower
> > than a bulk insert?
> >
> > Can I do it another way: create a stored procedure
> > for this bulk insert, then pin this procedure in
> > memory, does it still have RBS problem?
> >
> > Anyone has similar experience?
> >
> > Thanks in Advance,
> >
> > Chris
> >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Get email at your own domain with Yahoo! Mail.
> > http://personal.mail.yahoo.com/
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > --
> > Author: CC Harvest
> > INET: ccharvest_at_yahoo.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX:
> > (858) 538-5051
> > San Diego, California -- Public Internet
> > access / Mailing Lists
> >
> --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (or the name of mailing list you want to be removed
> > from). You may
> > also send the HELP command for other information
> > (like subscribing).
>
>
> =====
> Connor McDonald
> http://www.oracledba.co.uk (mirrored at
> http://www.oradba.freeserve.co.uk)
>
> "Some days you're the pigeon, some days you're the statue"
>
> ____________________________________________________________
> Do You Yahoo!?
> Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
> or your free @yahoo.ie address at http://mail.yahoo.ie
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: =?iso-8859-1?q?Connor=20McDonald?=
> INET: hamcdc_at_yahoo.co.uk
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Martin Kendall
> INET: Martin.Kendall_at_Rubus.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Witold Iwaniec INET: wiwaniec_at_novalistech.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Mon Mar 26 2001 - 10:34:39 CST
 |
 |