On Sunday, May 15, 2016, Mikael <mikael.trash at gmail.com> wrote: > > Would there be any facility whereby after each transaction I do on a > database or table, I could somehow make a snapshot so that at any future > point in time, I could easily do a SELECT to a given version/snaphot?
WAL basically does this already. But only in a transient manner. If you could retain the WAL file and never truncate it, you could. That's basically how Oracle does Flashback queries. But you also need SQL extension to say AS OF time stamp or SCN. Can also be at the API level (OCISnapshot* arg in OCI). --DD
