RE: sqlloader question

Lyuda,

According to the good ol' doc, when you use a direct load with the ROWS param, Loader will count the rows it's building into blocks, and 'save' the blocks when each time ROWS is reached.

I've used ROWS in direct loads, and it worked as advertised. The loads were still fast, and data was saved at the number of ROWS specified.

There is a difference between a 'save' during a direct load with ROWS, and a COMMIT during a conventional load with ROWS. According to the doc, the only difference is that during a direct load, any indexes are marked unusable. If the load crashes, 'saved' rows will still be there, and you're indexes will need to be recreated.

(You're indexes would need to be recreated anyway if a direct load crashes. Just that if you use ROWS, whatever's been saved so far is saved.)

Hope this helps somewhat,

Yosi

> -----Original Message-----
> From: lhoska_at_calibresys.com [mailto:lhoska_at_calibresys.com]
> Sent: Tuesday, July 03, 2001 1:02 PM
> To: Multiple recipients of list ORACLE-L
> Subject: sqlloader question
>
>
> Hello oradba's,
> I have a general question about sqlloader.
> There is an option called ROWS. According to Oracle Complete
> reference by
> G.Koch and K.Loney ROWS is the number of rows to buffer
> together for an
> insert and commit. Default value is 64.
> According to one of my coworkers specifying ROWS in combination with
> LOAD=DIRECT is not a good idea. Supposedly it will confuse
> and slow down
> the load, possibly throw it to a non-direct load. The theory
> is based on
> the following idea: during direct load sql loader is not
> supposed to count
> and commit records.
> Does it sound like true?
>
> Lyuda Hoska
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: lhoska_at_calibresys.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: 
  INET: Yosi_at_comhill.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).