Database Administration (MOSC)

MOSC Banner

I need to query the data for longer period than 4-5 days as of timestamp query Question ( which par

edited Feb 7, 2011 12:35AM in Database Administration (MOSC) 2 commentsAnswered
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

I need to know which parameter  to increase number of days. in the above query

 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center