OraFAQ Forum: Server Utilities » SQL*Loader - file path / error opening the file (merged)

Home » RDBMS Server » Server Utilities » SQL*Loader - file path / error opening the file (merged)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQL*Loader - file path / error opening the file (merged) [message #214336]

Mon, 15 January 2007 22:48

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

Report message to a moderator

Re: sql loader datafile and control file path [message #214337 is a reply to message #214336]

Mon, 15 January 2007 22:51

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

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

Mahesh Rajendran
Messages: 10708
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.

Report message to a moderator

Re: sqlldr 554:error opening the file [message #214353 is a reply to message #214348]

Tue, 16 January 2007 00:24

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

Report message to a moderator

Re: sql loader datafile and control file path [message #214354 is a reply to message #214337]

Tue, 16 January 2007 00:26

Littlefoot
Messages: 21823
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.

Report message to a moderator

Re: sql loader datafile and control file path [message #214355 is a reply to message #214354]

Tue, 16 January 2007 00:28

Littlefoot
Messages: 21823
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.

Report message to a moderator

Previous Topic:	SQL Loader question: How to use two WHEN clauses for a single table load
Next Topic:	import issues

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 05 19:23:37 CST 2024