2016-05-15 23:46 GMT+07:00 Dominique Devienne <ddevienne at gmail.com>:
> 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 > > Wait. What do you mean by "this", can you please elaborate? So yeah say I could skip checkpointing for a veery long time.
