SQL*Loader: Error 500/09/54
936666Oct 8 2012 — edited Oct 9 2012Hi 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!