OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » Sqlloader

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

Sqlloader [message #71908]

Mon, 03 February 2003 09:00

Ludo
Messages: 4
Registered: January 2003

Junior Member

My contol file :
load data
infile G:PHECISQLScriptsImportImportOracle_.sql
append
into table a013009.ImportTable
fields terminated by ","
("Date", ISIN, ..., Dummy)

My batch file :
SQLLDR USER/PWD control=ImportControl.ctl log=ImportControl.log bad=ImportControl.bad data=10

Error message :
Message 2100 not found; No message file product=RDBMS, facility=UL

My question :
What does mean this error message ?

Thanks
Ludo

Report message to a moderator

Re: Sqlloader [message #71909 is a reply to message #71908]

Mon, 03 February 2003 09:46

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

check you environment.
PATH and ORACLE_HOME
make sure ORACLE_HOME is included in your PATH.
and manually check whether u can invoke sqlldr from the directory u are trying to invoke it.
If you have multiple databases,
then set your ORACLE_SID or
use a connectstring.
SQLLDR USER/PWD@connectstring  control=ImportControl.ctl log=ImportControl.log bad=ImportControl.bad data=10

Report message to a moderator

Re: Sqlloader [message #71912 is a reply to message #71908]

Tue, 04 February 2003 00:53

Ludo
Messages: 4
Registered: January 2003

Junior Member

Thanks !

Ludo

Report message to a moderator

Previous Topic:	Importing Oracle 8.1.7 dump file into Oracle 8.1.6
Next Topic:	ORACLE9i Installation problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 15 20:24:18 CDT 2024