sql loader - copying SQLLDR from one Oracle install to another -
i writing shell script import text files oracle database. script has in turn invoke sqlldr
. discovered particular oracle install (let's call sys1) not have sqlldr
in reason, , can't update running installer. did find system (sys2) seemingly same version of oracle installed (11.2.0) has sqlldr.exe
in c:\oracle\product\11.2.0\client_1\bin
. copied exe file, plus whatever in on sys2 in c:\oracle\product\11.2.0\client_1\lib
missing form sys1. defined oracle_base
, oracle_home
. still, when invoke copied sqlldr.exe
on sys1, get:
message 2100 not found; no message file product=rdbms, facility=ulmessage 2100 not found; no message file product=rdbms, facility=ul
what else need able run transplanted exe on sys1? thx!
first thing missing %oracle_home%/rdbms/mesg/ulus.msb
fiel. there might more things missing after copy one.
Comments
Post a Comment