This discussion is archived
5 Replies Latest reply: Oct 9, 2012 3:41 AM by Paul M. RSS

SQL*Loader: Error 500/09/54

936666 Newbie
Currently Being Moderated
Hi I am getting the below error

SQL*Loader: Release 11.2.0.1.0 - Production on Mon Oct 8 19:27:31 2012

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

SQL*Loader-500: Unable to open file (control.ctl"åX#åx%å)
SQL*Loader-554: error opening file
SQL*Loader-509: System error: The device does not recognize the command.


Create table in my schema login as

Create table mytable(Col1 smallint,Col2 smallint);

in

Sqlldr userid=your userid/ password@database control=control.ctl

control.ctl is saved in C: path and containts

load data
infile 'D:\Oracle\TestData.txt'
into table Schema.mytable;
fields terminated by "," optionally enclosed by '"'
( Col1,Col2);

What is wrong with the above query.

Thanks!

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points