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