Hi
Have you checked any space between = in sqlldr syntax. That might
cause error.

Please do verify once again the syntax with any space is there or not

Thanks
Bala

-----Original Message-----
From: Kalpana R.
[mailto:oracledba-ezmlmshield-x22194684.[Email address protected]
Sent: Tuesday, May 31, 2005 5:20 PM
To: LazyDBA Discussion
Subject: RE: Sql loader SQL


Yes Bala , I have checked that too. The file exists there.

Regards,
Kalpana.
-----Original Message-----
From: balasubramanian
[mailto:oracledba-ezmlmshield-x14332097.[Email address protected]
Sent: Tuesday, May 31, 2005 5:18 PM
To: LazyDBA Discussion
Subject: RE: Sql loader SQL


Hi

SQL*Loader-500: Unable to open file (f:/sql.txt)

Check whether sql.txt file is there in your f: driver your
desktop/notebook.

Regards
Bala

-----Original Message-----
From: Kalpana R.
[mailto:oracledba-ezmlmshield-x79062932.[Email address protected]
Sent: Tuesday, May 31, 2005 5:12 PM
To: LazyDBA Discussion
Subject: Sql loader SQL

Hi,



I am encountering the following error when trying to load data from csv
file to a table in a schema through SQL Loader.





SQL*Loader-500: Unable to open file (f:/sql.txt)

SQL*Loader-553: file not found

SQL*Loader-509: System error: The system cannot find the file specified.



Can someone throw light on any possible reasons for the above?



Regards,

Kalpana.







--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html




Confidentiality Notice

The information contained in this electronic message and any attachments
to this message are intended
for the exclusive use of the addressee(s) and may contain confidential
or privileged information. If
you are not the intended recipient, please notify the sender at Wipro or
[Email address protected] immediately
and destroy all copies of this message and any attachments.


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html




Confidentiality Notice

The information contained in this electronic message and any attachments to this message are intended
for the exclusive use of the addressee(s) and may contain confidential or privileged information. If
you are not the intended recipient, please notify the sender at Wipro or [Email address protected] immediately
and destroy all copies of this message and any attachments.

Oracle LazyDBA home page