Sunday, May 15, 2016

running oracle sql scripts in nohup mode in unix os

ias_rest.sql

set heading on;
set feedback on;
alter session enable parallel dml;
spool ias_rest.log;
set time on;
set timing on;

INSERT /*+APPEND PARALLEL(X,4)*/INTO abc.PROD4.MEASUREMENT_HIGH X SELECT /*+PARALLEL(Y,4)*/* FROM abc_PROD4.MEASUREMENT_HIGH@to_src Y;
COMMIT;

spool off;


Execute:
nohup sqlplus mani/mani@prfengp @ias_rest.sql>ias_rest.out &

No comments:

Post a Comment