When i try to run a job in unix, i am getting
sqlload error as,
sqlload : file not found.
Can any one please let me know whats the reason for this..
The PATH & ORACLE_HOME paths names are correct...
thanks
hr is the script:
here is the script : plz hv a look
TABLE_NAME= tablename
CONTROL_FILE=ctrlname
typeset -i NO_OF_FILES= number
typeset -i I
((I = NO_OF_FILES - 1))
set -A TABLE_NAME_ARRAY table names
set -A LOG_NAME_ARRAY lognames
set -A DATA_FILE_ARRAY datafilesnames
set -A CONTROL_FILE_ARRAY control filesnames
set -A DR_IND_FILE_ARRAY ind filesnames
set -A CR_IND_FILE_ARRAY crind filenames
set -A ARCHIVE_FILE_ARRAY filenames
typeset -i INC=0
while ((INC <= I))
do
TABLE_NAME=${TABLE_NAME_ARRAY[$INC]}; export TABLE_NAME
LOG_NAME=${LOG_NAME_ARRAY[$INC]}; export LOG_NAME
DATA_FILE=${DATA_FILE_ARRAY[$INC]}; export DATA_FILE
CONTROL_FILE=${CONTROL_FILE_ARRAY[$INC]}; export CONTROL_FILE
DR_IND_FILE=${DR_IND_FILE_ARRAY[$INC]}; export DR_IND_FILE
CR_IND_FILE=${CR_IND_FILE_ARRAY[$INC]}; export CR_IND_FILE
TAR_FILE=${ARCHIVE_FILE_ARRAY[$INC]}; export TAR_FILE
date > ${LOG_HOME}/${LOG_NAME}.out
sqlplus -s $USER_ID/$USER_PWD @${SCRIPT_HOME}/truncate_table.sql $TABLE_NAME $USER_ID >> ${LOG_HOME}/${LOG_NAME}.out
mfi.sh $DATA_FILE ${LOG_NAME}.log ${LOG_NAME}.out $CONTROL_FILE PRELOAD $TABLE_NAME 0 > /dev/null
# Run the load script
sqlload $USER_ID/$USER_PWD,\
CONTROL=${SCRIPT_HOME}/${CONTROL_FILE},\
DATA=${DATA_DIR}/${DATA_FILE},ROWS=4000,\
BINDSIZE=500000,\
BAD=/tmp/${LOG_NAME}.bad,\
LOG=${LOG_HOME}/${LOG_NAME}.log >> /dev/null
print Analyzing table ${TABLE_NAME}... >> ${LOG_HOME}/${LOG_NAME}.out
sqlplus -s $USER_ID/$USER_PWD @${SCRIPT_HOME}/analyze_table.sql $TABLE_NAME >> ${LOG_HOME}/${LOG_NAME}.out
mfi.sh $DATA_FILE ${LOG_NAME}.log ${LOG_NAME}.out $CONTROL_FILE POSTLOAD $TABLE_NAME 0 > /dev/null
touch ${LOG_HOME_1}/${USER_ID}.${TABLE_NAME}.ready
((INC += 1))
done
06-02-2008
