Good day to you all:

I am having some problems using the SQL Loader utility. I am trying to load some data that were sent to us by our client. Went into command prompt and issued the following command:

Sqlldr userid=user/pswd data.clt data=data.dat

but was given the following error messages:

SQL*Loader 500-unable to open file (data.ctl)
SQL*Loader 553-file not found
SQL*Loader 509-system error, unable to locate specified file.

I then tried the following command:

Sqlldr userid=user/pswd control=data.ctl

and was given the same error message. I even tried to use the absolute path in both the command & control file, but to no avail.

the control file is as follow:

Load Data
infile data.dat
into table new_data
replace
fields terminated by ","
(col1,col2,col3,col4)

Both the data & control files were loaded onto the same temp folder in one of our partitioned drives. The destination tables are also on the same server, however under different drive.

Anyone has any idea what I did wrong, and how I can get this resolved. I have deadline to meet and in a rather dire situation. Thank you in advance for any helpful advice, help, and suggestion.

J.T

P.S: We use Oracle 8.16 running on Win NT 4.0