Home » RDBMS Server » Server Utilities » SQL*Loader - file path / error opening the file (merged)
SQL*Loader - file path / error opening the file (merged) [message #214336] Mon, 15 January 2007 22:48 Go to next message
vikram1780
Messages: 222
Registered: January 2007
Location: Bangalore
Senior Member
Hi,

In which directory the datafile and controlfile should be. Is it neccesary to give complete path of controlfile while invking it.

sqlldr userid uname/password control=load.ctl.

or

sqlldr userid uname/passsowrd control=c;\data\load.ctl.

Both control file and datafile should be in same folder.

Thanks
KUmar
Re: sql loader datafile and control file path [message #214337 is a reply to message #214336] Mon, 15 January 2007 22:51 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi it is depand on you OS USER default directory path

always better to give full path name with DATAFILE or CONTROLFILE.

regards
Taj

[Updated on: Mon, 15 January 2007 22:51]

Report message to a moderator

sqlldr 554:error opening the file [message #214342 is a reply to message #214336] Mon, 15 January 2007 23:45 Go to previous messageGo to next message
vikram1780
Messages: 222
Registered: January 2007
Location: Bangalore
Senior Member
Hi I am facing following error while runnning sql loader
sql*loader -500 unable to open the file
sql*loader -554 error opening file
sql*loader -509: system error: The device doesnt recognise the command

sql*loader -2026: The load was aboterd beacuse sql loader cannot continue.

Here is my control file

Load.ctl

load data
  infile 'c:\C:\Documents and Settings\c_vkudik\My Documents\vikram\book1.csv'
  into table sam1
  fields terminated by "," optionally enclosed by '"'		  
  ( scenario_id , item_id , description )


Book1.csv having complete permissions

Just can anyone help in resolving this error.

Thanks in advance

[Updated on: Mon, 15 January 2007 23:54] by Moderator

Report message to a moderator

Re: sqlldr 554:error opening the file [message #214348 is a reply to message #214342] Mon, 15 January 2007 23:54 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Quote:
infile 'c:\C:\Documents and Settings\c_vkudik\My Documents\vikram\book1.csv'

First the syntax is wrong.
you must post the sqlldr commands you used.
Re: sqlldr 554:error opening the file [message #214353 is a reply to message #214348] Tue, 16 January 2007 00:24 Go to previous messageGo to next message
vikram1780
Messages: 222
Registered: January 2007
Location: Bangalore
Senior Member

load data
infile 'C:\vikram\book1.csv'
into table MST_ITEM
fields terminated by "," optionally enclosed by '"'
( scenario_id , item_id , description )



sqlldr userid=mds/mds control=c:\vikram\load.ctl

control file is in same folder as datafile that is c:\vikram
Re: sql loader datafile and control file path [message #214354 is a reply to message #214337] Tue, 16 January 2007 00:26 Go to previous messageGo to next message
Littlefoot
Messages: 20897
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
It would be a good idea to make sure that directory into which you have installed SQL*Loader executable is part of the operating system path variable. As far as I can tell, Oracle Universal Installer does it itself during installation process. Doing so, you'll invoke it using its name (SQLLDR, for example) which will then search for control and data file in current directory. It means that you don't have to specify any directory at all.
Re: sql loader datafile and control file path [message #214355 is a reply to message #214354] Tue, 16 January 2007 00:28 Go to previous message
Littlefoot
Messages: 20897
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
@vikram1780: those questions are closely related. Please, do not open a new topic; continue discussion in existing one.
Previous Topic: SQL Loader question: How to use two WHEN clauses for a single table load
Next Topic: import issues
Goto Forum:
  


Current Time: Wed Dec 07 04:56:38 CST 2016

Total time taken to generate the page: 0.09217 seconds