Pls check the permissions of your file i.e. Read/Write. Also check the
front slash symbol(f:/sql.txt)...... Please try back slash (f:\sql.text)

Thanks & Regards
Biswa Ranjan Singh





"Kalpana R. " <oracledba-ezmlmshield-x22194684.[Email address protected]
05/31/2005 17:20

To
"LazyDBA Discussion" <[Email address protected]
cc

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



Oracle LazyDBA home page