涂抹Oracle—Flashback
摘要：
11.1 基于flashback查询过去的数据 a.基于时间的查询(as of timestamp) 构造表falsh_tbl,删除数据然后查询 SQL>select * from flash_tbl as of timestamp sysdate-5/1440; 恢复删除的数据 SQL>insert into flash_tblselect * from flash_tbl as of timestamp sysdate-5/1440 where idgrant execute on dbms_flashback to user; 获取SCN，然后删除操作并提... 阅读全文
posted @ 2013-12-16 22:20 newmanzhang 阅读(356) 评论(0) 推荐(0) 编辑
