Re: SQL*Loader-500: Unable to open file

could be the following:

1. check the pathname

LOAD DATA
INFILE 'annainv0812.txt' <-------

what i do i run sqlldr in the same directory with the control files and data files

or

2. the data file is open for some reason ??

good luck

george

> I am new to sqlldr and I am trying to export some excel files to
> Oracle db. I have already saved my files in CSV format and created a
> control file to load data in sqlldr. Somehow i am keep on getting the
> unable to open file error. Could anyone please tell me how to fix this
> error. I have tried giving the full pathname in the control file
> already, still the same problem.
>
> I am posting my log file. Any help will be appreiciated.
>
>
> SQL*Loader: Release 8.1.5.0.0 - Production on Sat Aug 10 15:12:01 2002
>
> (c) Copyright 1999 Oracle Corporation. All rights reserved.
>
> Control File: tblmeter.ctl
> Data File: WMFD.csv
> Bad File: WMFD.bad
> Discard File: none specified
>
> (Allow all discards)
>
> Number to load: ALL
> Number to skip: 0
> Errors allowed: 50
> Bind array: 64 rows, maximum of 65536 bytes
> Continuation: none specified
> Path used: Conventional
>
> Table TBLMETER, loaded from every logical record.
> Insert option in effect for this table: REPLACE
> TRAILING NULLCOLS option in effect
>
> Column Name Position Len Term Encl Datatype
> ------------------------------ ---------- ----- ---- ----
> ---------------------
> FROMWSAID FIRST * , O(") CHARACTER
> TOWSAID NEXT * , O(") CHARACTER
> METERDESC NEXT * , O(") CHARACTER
>
> SQL*Loader-500: Unable to open file (WMFD.csv)
> OSD-04002: unable to open file
> O/S-Error: (OS 2) The system cannot find the file specified.
>
>
> Thanks
Received on Mon Aug 12 2002 - 22:18:25 CEST