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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED]
> >
> > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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).
======================================
Witold Iwaniec
Senior Software Developer
NovaLIS Technologies
[EMAIL PROTECTED]
http://www.novalistech.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Witold Iwaniec
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
