闪回表



-- 开启行迁移

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

巴特西

oracle FLASHBACK TABLE

闪回表

最新文章

热门文章