Home » RDBMS Server » Server Utilities » Using SQLLDR
Using SQLLDR [message #72831] Wed, 12 November 2003 02:04 Go to next message
kjl
Messages: 48
Registered: June 2003
Member
Hi,

I try to use SQLLDR, but when I try to run it I got error-message:

"Message 2100 not found; No message file for product=RDBMS, facility=ULMessage 2100 not found; No message file for product=RDBMS, facility=UL"

Can you tell what is wrong?

BR K
Re: Using SQLLDR [message #72833 is a reply to message #72831] Wed, 12 November 2003 05:35 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
what is the OS?
check your PATH, ORACLE_HOME variables are pointing to the right area.
Re: Using SQLLDR [message #73282 is a reply to message #72831] Tue, 16 March 2004 12:38 Go to previous messageGo to next message
Hal
Messages: 1
Registered: March 2004
Junior Member
Getting "message 2100 not found" blah blah blah

The Oracle system is running on W2k box.

The system should work like this.....

computer 1 starts batch program
batch program copies files from computer 2
computer 2 batch program continues and
calls batch program on computer 2
computer 2 batch program executes sqlldr
on computer 3 to load file from computer 2
into table

I have tried the setlocal and endlocal commands in
the batch program on computer 2 but still get
the message......

any ideas would be appreciated.....
Re: Using SQLLDR [message #73450 is a reply to message #72831] Mon, 03 May 2004 13:40 Go to previous messageGo to next message
Maryann
Messages: 1
Registered: May 2004
Junior Member
Yes. Changing the path corrects this problem.

thanks!
Re: Using SQLLDR [message #74373 is a reply to message #72831] Tue, 30 November 2004 20:05 Go to previous message
chandy
Messages: 1
Registered: November 2004
Junior Member
hi guys,
check the following.
1.set env variables like ORACLE_HOME, LD_LIB_PATH properly.

2. check the message files ORACLE_HOME/rdbms/mesg.
it must have some 19 files. if its less the message files are missing. u can copy those from some other installtion for sqllldr to start working.
Previous Topic: Replace External Table Files
Next Topic: external table. Data not fetching
Goto Forum:
  


Current Time: Wed Jul 03 01:23:00 CDT 2024