sqlplus /nolog <<EOF
conn system/….
set time on
set echo on
set heading on
set feedback on
spool SN_20150608_01_ODS_Scripts_Prd_v1.log
ALTER SESSION SET CURRENT_SCHEMA=ODS;
@SN_20150608_01_ODS_Scripts_Prd_v1.sql
spool off
spool SN_20150608_01_DW_Scripts_Prd_v1.log
ALTER SESSION SET CURRENT_SCHEMA=DW;
@SN_20150608_01_DW_Scripts_Prd_v1.sql
spool off
EOF
