Oracle-L: RE: Parallel load direct path

From: Khedr, Waleed <Waleed.Khedr_at_FMR.COM>
Date: Tue, 23 Apr 2002 06:28:45 -0800
Message-ID: <F001.0044C7D3.20020423062845@fatcity.com>

Yes if you use the row option. In your case assume you were using many concurrent load sessions, and probably one of these sessions completed before getting this error.

-----Original Message-----
To: Multiple recipients of list ORACLE-L Sent: 4/23/02 9:28 AM

I don't have row set to anything. Does SQL*Loader in direct more commit/saves the data it already put into a table if the proces fails?

Gene
--- "Khedr, Waleed" <Waleed.Khedr_at_FMR.COM> wrote:
> sqlldr has rows option: rows -- Number of rows in
> conventional path bind
> array or between direct path data saves
> (Default: Conventional path 64,
> Direct path all)
>
> Waleed
>
> -----Original Message-----
> Sent: Monday, April 22, 2002 6:07 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi.
>
> We are loading tables using Ab Initio and SQL*Loader
> in paralel in direct path mode. Now today the
> process
> failed. I thought that no records would be added to
> the table, but we seem to found about 64000 of them
> in
> the table. How/why would this happen? Thanks for any
> insight
>
> Gene
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Games - play chess, backgammon, pool and more
> http://games.yahoo.com/
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Gurelei
> INET: gurelei_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).
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Khedr, Waleed
> INET: Waleed.Khedr_at_FMR.COM
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists

>

Do You Yahoo!?
Yahoo! Games - play chess, backgammon, pool and more http://games.yahoo.com/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gurelei
  INET: gurelei_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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Khedr, Waleed
  INET: Waleed.Khedr_at_FMR.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 Tue Apr 23 2002 - 09:28:45 CDT