iMES:MES定期刪除Log檔資料

--清除一個月前資料 --MES系統交易紀錄表 Delete tblSYSErrorLog Where RecordDate < add_months(sysdate,-1); Delete tblSYSEventLog Where RecordDate < add_months(sysdate,-1); --MES&ERP整合交易紀錄表 Delete tblERPTransactionXMLLog Where ID in (Select ID From tblERPTransactionLog Where CreateDate < add_months(sysdate,-2)); Delete tblERPTransactionLog Where CreateDate < add_months(sysdate,-2); Delete tblMESAutorunLog Where Endtime < add_months(sysdate,-2); --回復交易紀錄表 Delete tblWIPReverseUNCommit Where LotSerial in (Select LotSerial From tblWIPReverseHistory Where CreateDate < add_months(sysdate,-1)); Delete tblWIPReverseUpdateContent Where LotSerial in (Select LotSerial From tblWIPReverseHistory Where CreateDate < add_months(sysdate,-1)); Delete tblWIPReverseHistory Where CreateDate < add_months(sysdate,-1); Delete tblWIPReverseLog Where CreateDate < add_months(sysdate,-1); --清除一周前資料 --MES系統交易紀錄表 Delete tblSYSErrorLog Where RecordDate < (sysdate - 7); Delete tblSYSEventLog Where RecordDate < (sysdate - 7); --MES&ERP整合交易紀錄表 Delete tblERPTransactionXMLLog Where ID in (Select ID From tblERPTransactionLog Where CreateDate < (sysdate - 7)); Delete tblERPTransactionLog Where CreateDate < (sysdate - 7); Delete tblMESAutorunLog Where Endtime < (sysdate - 7); --回復交易紀錄表 Delete tblWIPReverseUNCommit Where LotSerial in (Select LotSerial From tblWIPReverseHistory Where CreateDate < (sysdate - 7)); Delete tblWIPReverseUpdateContent Where LotSerial in (Select LotSerial From tblWIPReverseHistory Where CreateDate < (sysdate - 7)); Delete tblWIPReverseHistory Where CreateDate < (sysdate - 7); Delete tblWIPReverseLog Where CreateDate < (sysdate - 7);