oracle FLASHBACK TABLE

闪回表

-- 开启行迁移
ALTER TABLE employees_test
   ENABLE ROW MOVEMENT;
   

UPDATE employees_test
  SET salary = salary * 1.1
  WHERE salary < 2500;

5 rows updated.
COMMIT;

-- 按时间戳闪回
FLASHBACK TABLE employees_test
  TO TIMESTAMP (SYSTIMESTAMP - INTERVAL '1' minute);
  
-- 闪回到drop前
FLASHBACK TABLE print_media TO BEFORE DROP;

-- 闪回后改名
FLASHBACK TABLE print_media TO BEFORE DROP RENAME TO print_media_old;

-- 查看回收站
SELECT object_name, droptime FROM user_recyclebin 
   WHERE original_name = 'PRINT_MEDIA';

OBJECT_NAME                    DROPTIME
------------------------------ -------------------
RB$$45703$TABLE$0              2003-06-03:15:26:39
RB$$45704$TABLE$0              2003-06-12:12:27:27
RB$$45705$TABLE$0              2003-07-08:09:28:01

Refer to: FLASHBACK TABLE