1 2 3 4 5 6 7 8 9 10 11 12 13 14
| clear
. /exploit/scripts/oracle/otcghh
echo `date`
sqlplus tiht/tiht << EOF
INSERT INTO M4SPH_MANDAT SELECT * FROM M4SPH_MANDAT_ARC;
INSERT INTO SPH_GL_AC_PERIOD SELECT * FROM SPH_GL_AC_PERIOD_ARC;
commit;
SELECT COUNT(*) FROM SPH_GL_AC_PERIOD;
SELECT COUNT(*) FROM M4SPH_MANDAT;
execute DBMS_STATS.GATHER_TABLE_STATS (OwnName => 'RES',TabName => 'SPH_GL_AC_PERIOD', Method_Opt => 'FOR ALL COLUMNS SIZE 1', Cascade => TRUE,No_Invalidate => FALSE, Force => TRUE);
execute DBMS_STATS.GATHER_TABLE_STATS (OwnName => 'RES',TabName => 'M4SPH_MANDAT', Method_Opt => 'FOR ALL COLUMNS SIZE 1', Cascade => TRUE,No_Invalidate => FALSE, Force => TRUE);
@CreeIndxTableSPH_GL_AC_PERIOD.sql;
exit;
EOF |