Database Administration (MOSC)

MOSC Banner

Using flashback queries.

edited Sep 24, 2009 5:02AM in Database Administration (MOSC) 2 commentsAnswered
 Hi

I have a  fixed tablespace of size 32 gigs with Undo retention set to 1800 secs. The retention gurantee isnt set. If I want to use a flashback query as of timestamp (sysdate-3), do I need to increase the undo retention and apply retention gurantee? There are some over heads of using retention gurantee, like the dml might fail since the undo tbs isnt autoextending. What is the best way to acheive the flashback upto maximum 5 days. I cannot change the undo tbs to autoextend du to reasons.

Thanks in advance for the answer.

Regards

KLA

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