No you are not mistaken. Are you sure the table had no records before
loading? Look at the log file.
-----Original Message-----
To: Khedr, Waleed; 'Multiple recipients of list ORACLE-L '
Sent: 4/23/02 9:24 AM
I have done a test and only ran one session, which has
faile (ran out of space). Yet the changes to oracle
tables have been committed. I thought that in direct
load the changes are committed only when the load is
completed successfully. Was I wrong?
- "Khedr, Waleed" <Waleed.Khedr_at_FMR.COM> wrote:
> 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-----
> From: Gurelei
> To: Multiple recipients of list ORACLE-L
> Sent: 4/23/02 9:28 AM
> Subject: RE: Parallel load direct path
>
> 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
> >
>
> > 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).
>
>
> __________________________________________________
> 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).
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: 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 - 10:28:37 CDT