--閃回 回退已洗掉的資料 select * from NCMS_SPECIALIST_CHRONIC as of timestamp to_timestamp('2019-12-16 9:04:00', 'yyyy-mm-dd hh24:mi:ss'); --開啟這張表的狀態 alter table NCMS_SPECIALIST_CHRONIC enable row movement; flashback table NCMS_SPECIALIST_CHRONIC to timestamp TO_TIMESTAMP('2019-12-16 9:04:00', 'yyyy-mm-dd hh24:mi:ss'); --關閉 alter table NCMS_SPECIALIST_CHRONIC disable row movement;
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/21723.html
標籤：Oracle
上一篇：SQL Tuning Health-Check Script (SQLHC) (檔案 ID 1366133.1)
下一篇：利用OGG進行資料庫表的初始化