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

[jrldallas]

I am trying to load a document into a BLOB column in Oracle 9i using SQL*Loader example from the Oracle Text Refernce Guide and I get the following error stack:

SQL*Loader-502: unable to open data file ' S:\A.PDF' for field TEXT table ARTICLES_FORMATTED
SQL*Loader-553: file not found
SQL*Loader-509: System error: The system cannot find the file specified.
Commit point reached - logical record count 1

I have used SQL*Loader extensively on UNIX but never with LOBFILES before.

The sql*loader control file is as follows:

--Taken from P484 of Oracle Text Refrence Manual

load data
INFILE 'S:\text_demo\sql_loader\text_demo.dat'
INTO TABLE articles_formatted
APPEND
FIELDS TERMINATED BY ','
(article_id SEQUENCE (MAX,1),
author CHAR(30),
format,
pub_date SYSDATE,
title,
ext_fname FILLER CHAR(80),
text LOBFILE(ext_fname) TERMINATED BY EOF)

and my one line data file is:

Oracle, PDF, TextTips, S:\A.PDF,

I have reduced the document name down to S:\A.PDF to try and eliminate any capitalisation problems as I read somewhere that this filename is case sensitive. As I am running on Windows XP, I'm not sure what case the files are stored in by default but I have tried all of the combinations.

I have serached high and low on the internet and tried to use a procedure using the dbms_lob package but I get much the same error, saying it can't find the source file.

If anyone has any suggestions I would be most grateful.

James

 

[cgswong]

Since the LOBFILE entries in the datafile contain a path try enclosing them in single quotes like:

Oracle,PDF,TextTips,'S:\A.PDF',

Otherwise, you might want to try running the SQL*Loader from the same directory as the load file and control file. Then you'll know if it's a path, quotation, or control file specification issue. The ONE ( HP-UX + Solaris + AIX + Tru64 = Unix)