Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

sqlldr not finding file

722955May 11 2010 — edited May 12 2010

I have the following SQL*Loader control file.

LOAD DATA
CHARACTERSET UTF8
INFILE *
INTO TABLE IMPORTRAWXML TRUNCATE
(
SITEID constant 0
,VENDORID constant 17
,SITEFORMATID constant 2
,V17_standard_test.xml filler char(1000)
,RAWDATA LOBFILE (V17_standard_test.xml) TERMINATED BY EOF
)
BEGINDATA
V17_standard_test.xml

When I use it in the TOAD for Oracle import wizard, it works perfectly. When I run it from the sqlldr command line argument I get the following error message.

SQL*Loader-502: unable to open data file 'V17_standard_test.xml' for field RAWDA
TA table IMPORTRAWXML
SQL*Loader-553: file not found
SQL*Loader-509: System error: The system cannot find the file specified.

My command line call is:

sqlldr UID/password@SERVER 'P:\folder1\folder2\importrawxml.ctl'

There seems to be no issue accessing the control file. The issue is accessing the file that needs to be loaded. Any ideas?

Thanks!
Eva