Connected.

0 rows deleted.

prtnrSynonym.ksh[57]: /partnerdb/bin/prtnrLoadMetadata.ksh dataload prtnrAcxiomMetadataA.:  not found

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

IFS=$(echo '\012\001') # Newlines only
SQL="
        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 'DELETE PARTNERDBA.ACXIOM_METADATA_B;'
                    ELSE 'DELETE PARTNERDBA.ACXIOM_METADATA_A;'
               END text
              ,CASE WHEN table_name = 'ACXIOM_METADATA_A'
                    THEN '$PARTNER_DB/prtnrLoadMetadata.ksh ${USERID} ${CONTROL_FILEB} ${DATA_FILE}'
                    ELSE '$PARTNER_DB/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';
"
for LINE in $(
    sqlplus -s /nolog <<EOF
    ${SQL}
EOF)
do
    case ${LINE} in
        DELETE*|CREATE*)
            sqlplus -s /nolog <<!
connect ${DB_USER}/${DB_PASSWORD}@${DB_NAME}
${LINE}
!
 ;;
        $PARTNER_DB/prtnrLoadMetadata*) exec ${LINE} ;;
    esac
done