there some ways, one of it flashback table to 5 minutes before
flashback table MyTable to timestamp to_timestamp(sysdate-5/1440) --five minutes ago
or you can just query it (not changing table) (flashback query)
SELECT * FROM MyTable AS OF TIMESTAMP (sysdate -5 /1440);
but these are not work for a very long time
because these flasback technologies use undo data.
PS: to use flashback table, you need to enable
row movement on the table.
select * from demo as of timestamp to_timestamp('2012-09-29 16:44:31','yyyy-mm-dd hh24:mi:ss');
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/26477398/viewspace-2122493/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
FRA空间满
请登录后发表评论
登录
全部评论
