Question:

Hello Everyone,
I am currently trying to load a 30mb dat file into a table with sqlldr.
I know that I need to use the commit=y command but I am not sure of the
syntax to use with sqlldr. All the examples I have seen for commit=y
are for imp. Where do I use the commit=y in the command line aruments
or in the control file. An example would be great thanks.

Answer:

sqlldr ... rows=<n>

ROWS identifies the number of rows per commit:

Conventional path loads: ROWS specifies the number of
rows in the bind array.
The default is 64.

Direct path loads: ROWS identifies the number of rows
you want to read from the data file before a data save.
The default is to save data once at the end of the load.