USERID=$1
DATA_FILE=$2
CONTROL_FILEA=prtnrAcxiomMetadataA.ctl
CONTROL_FILEB=prtnrAcxiomMetadataB.ctl

IFS=$(echo '\012\001') # Newlines only
for LINE in $(
    sqlplus -s /nolog <<!
        CONNECT ${DB_USER}/${DB_PASSWORD}@${DB_NAME}
        SET FEEDBACK OFF VERIFY OFF ECHO OFF PAGES 0 TRIMSPOOL ON
        COL text FORMAT A150 FOLD_AFTER
        SELECT CASE WHEN table_name = 'ACXIOM_METADATA_A'
                    THEN 'TRUNCATE TABLE PARTNERDBA.ACXIOM_METADATA_B;'
                    ELSE 'TRUNCATE TABLE PARTNERDBA.ACXIOM_METADATA_A;'
               END text
              ,CASE WHEN table_name = 'ACXIOM_METADATA_A'
                    THEN 'prtnrLoadMetadata.ksh ${USERID} ${CONTROL_FILEB} ${DATA_FILE}'
                    ELSE 'prtnrLoadMetadata.ksh ${USERID} ${CONTROL_FILEA} ${DATA_FILE}'
               END text
              ,CASE WHEN table_name = 'ACXIOM_METADATA_A'
                    THEN 'CREATE OR REPLACE PUBLIC SYNONYM ACXIOM_METADATA FOR ACXIOM_METADATA_B'
                    ELSE 'CREATE OR REPLACE PUBLIC SYNONYM ACXIOM_METADATA FOR ACXIOM_METADATA_A'
               END text
        FROM   all_synonyms
        WHERE  synonym_name = 'ACXIOM_METADATA';
!)
do
    case ${LINE} in
        TRUNCATE*|CREATE*)
            sqlplus -s /nolog <<!
connect ${DB_USER}/${DB_PASSWORD}@${DB_NAME}
${LINE}
!
 ;;
        prtnrLoadMetadata*) exec ${LINE} ;;
    esac
done