Hi team,
As I am using certain flashback queries on a table to retrieve certain data, so for example, I have used one of these:
select * from service_req_prod versions between timestamp
to_timestamp('2021-07-03 09:22:33', 'YYYY-MM-DD HH:MI:SS')
and
to_timestamp('2021-07-04 09:22:33', 'YYYY-MM-DD HH:MI:SS');
So, the above query is giving me the error:
ORA-08180: no snapshot found based on specified time
What does the above error mean? Does it mean that there was not any data present during that timeline? I am certain that I did lose 1-2 rows of data, but like the above queries , I have tried other queries as well but its showing the same error. Is there any problem with the query? How should I approach this issue?
Thanks and regards
Ankan