Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how long back can oracle query flashback

spur230Nov 12 2009 — edited Nov 13 2009
Hi Everybody,

I am using Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi.

The database has undo_retention value of 14400 which is 4 hours.

However , I can flashback any table upto 5 days back.

select * from tablename as of timestamp sysdate -5

When I flashback sysdate -6 it give me error no snapshot found.

I want to now what parameter in database determines how long back I can flash back?

Any help is greatly appriciated.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 11 2009
Added on Nov 12 2009
#general-database-discussions
3 comments
1,045 views