In today’s article, we will examine the “ORA-08180” error when trying to see the changes in a table with “AS OF TIMESTAMP” in the Oracle database.
Error:
ORA-08180: No Snapshot Found Based On Specified Time
Solution:
Oracle database can keep the changes in the table on a row basis using Flashback Query technology.
This technology, which is limited to a maximum of 5 days in a 10G database, is connected to the Oracle Database 11G and UNDO_RETENTION parameter and acts according to the values here.
Accordingly, we can say that the error occurs because the REDO LOG size is not enough.
As a solution to the error, we can set UNDO_MANAGEMENT = AUTO, increase the UNDO_RETENTION value and edit the RETENTION_GARANTEE parameter to guarantee a certain time.
