Recently, I have been contacted several times by developers following manipulation errors that led to unwanted deletions of rows in a table on Oracle database. This can unfortunately happen frequently, especially on test or development environments.
The first thing that comes to mind is to restore a full backup of the database or perform a restore of the tablespace where the table is located (TSPITR) to retrieve the deleted rows. But there may be another faster solution if you do it quickly: using “Oracle Flasback Query“.
This feature can also be used to compare the content of a table with its content in the past, see the rows inserted/deleted/updated since a certain time,…
Continue reading “How “Oracle Flashback Query” can save you from performing a full database restore or a TSPITR”