b1nary0mega
6/8/2015 - 1:57 PM

Copy over old access log data and delete from the current backup table

Copy over old access log data and delete from the current backup table

/* INSERT INTO BACKUP TABLE */
INSERT INTO USER_ACCESS_LOG_2014
SELECT * FROM USER_ACCESS_LOG
WHERE ACCESS_DATE >= TO_DATE('01-01-14 00:00:00','mm-dd-yy hh24:mi:ss')
AND ACCESS_DATE <= TO_DATE('12-31-14 00:00:00','mm-dd-yy hh24:mi:ss');

COMMIT;

/* DELTE INSERTED DATA */
DELETE FROM USER_ACCESS_LOG
WHERE ACCESS_DATE >= TO_DATE('01-01-14 00:00:00','mm-dd-yy hh24:mi:ss')
AND ACCESS_DATE <= TO_DATE('12-31-14 00:00:00','mm-dd-yy hh24:mi:ss');

COMMIT;