sqlplus -s $CONNECT <<END_SCRIPT
set verify off
set echo off
CREATE TABLE TEMP_MAPE
(
  X_EXTERNAL_ID             NUMBER,
  X_OFFER_ID                 NUMBER,
  SEQ_ID                     NUMBER     NOT NULL
);
COMMIT;
CREATE UNIQUE INDEX IN_MAPE_U01 ON TEMP_MAPE
(SEQ_ID);
COMMIT;
exit
END_SCRIPT

plist=`ps -e -o "pid args"|grep sqlldr |grep -v grep |awk '{print $1}'`

if [ -z "$plist" ]; then

sqlldr userid=$CONNECT control=load.ctl direct=TRUE

sqlplus -s $CONNECT <<END_SCRIPT
CREATE INDEX IN_X1 ON TEMP_MAPE
(X_EXTERNAL_ID);
COMMIT;
exit
END_SCRIPT
fi