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