Infrastructure Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Loader in .csh file (KSH)

594614Oct 29 2008 — edited Oct 29 2008

Hi,

We have some scripts (.sh and .csh) in on our UNIX boxes, Oracle 10G. To load data in tables we call sqlldr. Interestingly our .sh files are working fine but not .csh script. If we set SID manually .csh script runs correctly. How do i set SID for .csh files. Here is the sample code that i have

setenv ORACLE_HOME /folder/oracle/product/10.2.0
setenv PATH {$PATH}:{$ORACLE_HOME/bin}
setenv LD_LIBRARY_PATH $ORACLE_HOME/lib
setenv TNS_ADMIN $work_root/common

here is the call
sqlldr $DB_LOGIN data=$PRCS_FILE control=$CTL_FILE log=$SQL_LDR_LOG

$DB_LOGIN contains db credentials in form username/password and same is accepted in .sh scripts. Let me know if you need more info.

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 26 2008

Added on Oct 29 2008

#generic-linux, #linux

2 comments

1,295 views