SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problem with sqlldr and commit

inter1908Oct 3 2009 — edited Oct 5 2009

Hi,
i have a problem with sqlldr and commit.

I have a simple table with one colum [ col_id number(6) not null ]. The column "col_id" is primary key in the table. I have one file with 100.000 records ( number from 0 to 99.999 ).
I want load the file in the table with sqlldr ( sql*loader ) but i want commit only if all records are loaded. If one record is discarded i want discarded all record of file.

The proble is that in coventional path the commit is on 64 row but if i want the same records of file isn't possible and in direct path sqlldr disable primary key :(

There are a solutions?

Thanks

I'm for the bad English

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 2 2009

Added on Oct 3 2009

27 comments

5,621 views