系統表空間使用率 >90%,需清理歷史備份表(命名含 BAK 或日期後綴)。
SELECT owner, num_rows * avg_row_len, table_name FROM dba_tables WHERE table_name LIKE '%BAK%' AND REGEXP_LIKE(table_name, '\d+') AND table_name NOT LIKE 'T_IM_INVENTORY%' AND table_name NOT LIKE 'VT%' AND table_name NOT LIKE 'NCM%' AND table_name NOT LIKE 'T_HR_SCHM%' AND table_name NOT LIKE 'SYS%' AND owner = 'JINGYA';共計近 100 GB。
三天後財務報表缺資料,確認為誤刪 T_CSL_ITEMDATAENTRY001。
SELECT object_name, original_name, partition_name, type, ts_name, createtime, droptime FROM recyclebin WHERE original_name = 'T_CSL_ITEMDATAENTRY001';
FLASHBACK TABLE "BIN$AP6V8ohdAaLgU8CoZGEBog==$0" TO BEFORE DROP;
SELECT COUNT(*) FROM T_CSL_ITEMDATAENTRY001;
RECYCLEBIN=ON)是閃回 DROP 的前提。