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!

Commit point in SQL loader

user601042Jun 22 2010 — edited Jun 22 2010

Hi ,
Using Sqlloader i'm loading data into table. In the control file i mentioned following option to commit every 1024 rows.

But when actually SQLloader loads the data i'm getting follwowing output ie its commiting every 330 rows.

OPTIONS (ROWS=1024)
LOAD DATA
INFILE '$infile'
BADFILE '$badfile'
APPEND
INTO TABLE employee
.....
.....

SQL*Loader: Release 10.2.0.4.0 - Production on Tue Jun 22 06:13:23 2010

Copyright (c) 1982, 2007, Oracle. All rights reserved.

Commit point reached - logical record count 330
Commit point reached - logical record count 660
Commit point reached - logical record count 990

Can anyone help me on this?

Thanks,
Kannan

This post has been answered by SomeoneElse on Jun 22 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 20 2010

Added on Jun 22 2010

1 comment

1,648 views