SQL & PL/SQL

Hi,

I was wondering if somebody would be able to point me in the right direction with regards to how I can optimize the time it's currently taking me to load the thousands of records I load every fortnight. Using SQLLDR, the contents of the batch file looks like this:

SQLLDR username/password@database CONTROL=load_control.txt skip=12

Inside the load_control.txt file is the following code:

options (errors=1000)

LOAD DATA

INFILE 'data.csv' BADFILE 'bad_records.bad'

APPEND INTO TABLE owner.table
FIELDS TERMINATED BY "," optionally enclosed by '"'
trailing nullcols

*(*
FIELDS "function()",
FLAG CONSTANT "flagged"
*)*

The reason I've provided the above parameters/code is because I understand there are direct methods of loading. I've tried my best to read up on this but I can't find the relevant optimizing technique as I'm rather new to modifying the behaviour of SQLLDR.

By the way, there are no indexes on the table in question.

Thanks a lot in advance, this would be a great help if I could speed this loading up a bit,

Dan