RE: Parallel load direct path

2002-04-23 Thread Gurelei
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 [EMAIL PROTECTED] wrote: sqlldr has rows option: rows -- Number of rows in conventional path bind array or between direct path data

RE: Parallel load direct path

2002-04-23 Thread Khedr, Waleed
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.

RE: Parallel load direct path

2002-04-23 Thread Gurelei
: 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 [EMAIL PROTECTED] wrote: sqlldr has rows option: rows -- Number of rows in conventional path bind

RE: Parallel load direct path

2002-04-23 Thread Khedr, Waleed
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

RE: Parallel load direct path

2002-04-23 Thread Gurelei
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 [EMAIL PROTECTED] wrote

RE: Parallel load direct path

2002-04-23 Thread Khedr, Waleed
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

Parallel load direct path

2002-04-22 Thread Gurelei
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

RE: Parallel load direct path

2002-04-22 Thread Khedr, Waleed
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.