oracle笔记

32 阅读1分钟

oracle回滚数据: select * from 表 as of timestamp to_timestamp('2023-02-23 11:00:38', 'yyyy-mm-dd hh24:mi:ss');

--alter table 表 enable row movement;

--flashback table 表 to timestamp TO_TIMESTAMP('2023-02-24 11:00:38', 'yyyy-mm-dd hh24:mi:ss');