Friday, August 10, 2018

Oracle has a feature called Flashback Database.

It keeps old snapshots in a cache and is memory expensive. You may recreate old data with queries like so:

SELECT * FROM MyTable AS OF '2018/03/17 13:23:45'

 
 

Addendum 8/13/2018: The query above is probably wrong. See: this

No comments:

Post a Comment