Getting following error in sqlloader

Asked Nov 27 '12 at 10:02

Active Nov 27 '12 at 10:03

Viewed 3,611 times

SQL*Loader-500: Unable to open file (C:\sqlloaderpra\tmp.txt) SQL*Loader-553: file not found SQL*Loader-509: System error: The system cannot find the file specified. SQL*Loader-2026: the load was aborted because SQL Loader cannot continue.

Where my ctrl file is

load data
infile 'C:\sqlloaderpra\tmp.txt'
into table tmpload
append
fields terminated by ","
trailing nullcols
(
a Integer external,
b char nullif b=blanks)

Files are there but i get this error.

edited Nov 27 '12 at 10:03

Robert

25,425
8
67
81

asked Nov 27 '12 at 10:02

Satheesh K

Did you try move the file to another location? – Robert Nov 27 '12 at 10:09
Maybe to `D:\sqlloaderpra\` ? – Robert Nov 27 '12 at 10:15
Maybe you have problem with privileges. – Robert Nov 27 '12 at 10:22
No i have only one drive in it.couldnt find y this causing – Satheesh K Nov 27 '12 at 10:23
2

do this in a DOS window. `dir /q C:\sqlloaderpra\*txt` does it show you the file, and if so, is the owner your own login? – DazzaL Nov 27 '12 at 10:25
1

When i view this i got tmp.txt.txt .I modified to tmp.txt..Its working. Thank you so much DazzaL – Satheesh K Nov 27 '12 at 10:33

Getting following error in sqlloader

0 Answers0