Flashback Query

How to Resolve ORA-08186: invalid timestamp specified

by Ed Chen
March 17, 2023March 21, 2023

ORA-08186 Tried to perform a flashback query, but it failed with ORA-08186. SQL> select count(*) cnt from t1 as of timestamp to_timestamp('3023-02-20 00:53:08', 'yyyy-mm-dd hh24:mi:ss');… Read More »

How to Resolve ORA-01466: unable to read data - table definition has changed

by Ed Chen
March 16, 2023March 21, 2023

ORA-01466 Tried to perform a flashback query, but it failed with ORA-01466. SQL> select count(*) cnt from t1 as of timestamp to_timestamp('2023-02-19 22:15:00', 'yyyy-mm-dd hh24:mi:ss');… Read More »

How to Enable Flashback Query and Flashback Transaction Query

by Ed Chen
May 29, 2018December 26, 2022

This post is actually an extension of another post: How to Enable Flashback Database. I recommend it to you before reading this post. However, it's… Read More »