Friday , July 19 2024

ORA-08180: No Snapshot Found Based On Specified Time

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.


ORA-08180: No Snapshot Found Based On Specified Time


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.


About Buğra PARLAYAN

Burgra Parlayan is an experienced Database and Weblogic Administrator. After completing his technical / relevant training he has got involved with a serious amount of projects. He successfully managed database upgrade, database migration, database performance tuning projects for various public institutions.Currently he has been employed by one of the leading financial institutions called Turkiye Hayat & Emeklilik as responsible administrator for Oracle Database and Oracle Middleware. He has been sharing his experience and knowledge by face to face training, personal blog and various social networking accounts to support the Oracle ecosystem continuously since 2010.

Leave a Reply

Your email address will not be published. Required fields are marked *