Shell Programming and Scripting

sqlplus -s $user@$pass@inst << EOF
set echo off head off feed off pagesize 0 trimspool on linesize 1000 num 15 colsep ,
spool data.csv
select Field_1, Field_2 from table_1;
spool off;
exit;
EOF

while IFS=, read val_1 val_2
do
        sqlplus -s $user@$pass@inst << EOF
        delete from table_2 where Field_1='$val_1' and Field_2='$val_2';
        commit;
        exit;
        EOF
done < data.csv

1. Export (exp) & Import (imp) table from 1st DB to 2nd DB and join them to perform your task.
2. Spool all the values from table, use SQL Loader (sqlldr) to load them into a table in 2nd DB and join them to perform your task.