Using SQLLDR [message #72831] |
Wed, 12 November 2003 02:04 |
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 #73282 is a reply to message #72831] |
Tue, 16 March 2004 12:38 |
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 #74373 is a reply to message #72831] |
Tue, 30 November 2004 20:05 |
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.
|
|
|