I need to query the data for longer period than 4-5 days as of timestamp query Question ( which par
SQL> select * from test as of timestamp(systimestamp - interval '10' day);
select * from test as of timestamp(systimestamp - interval '10' day)
*
ERROR at line 1:
ORA-08180: no snapshot found based on specified time
select * from test as of timestamp(systimestamp - interval '10' day)
*
ERROR at line 1:
ORA-08180: no snapshot found based on specified time
I need to know which parameter to increase number of days. in the above query
0