Dumb question...=20 Why not have a stand-by database that is always 5 - 6 days behind ? If you need to get the information from 5 days ago, put standby in read = mode and select it from across a database link. Babette Turner-Underwood -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx = [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Connor McDonald Sent: 2004-02-12 1:15 AM To: oracle-l@xxxxxxxxxxxxx Subject: Re: Undo Retention of 5 days; anyone? I'd say the issue is not "5 days", but how much is "5 days worth of = transactions". If there is lots (of txns) thats sounds like a very very big undo tablespace...It = might almost be easier just to have 5 copies of the database, marked "today", "today-minus-one" etc = - which would be far quicker to query :-) Cheers Connor --- Arup Nanda <orarup@xxxxxxxxxxx> wrote: > List, > I have a very unusual request from users to have UNDO_RETENTION set to = 5 days. Normally I set to > about 5 hours, not days. Don't ask why. They have inherited a bad = design that requires flashing > back to 5 days ago and, no, they can't redesign it. >=20 > I'm curious if anyone has actually done it, i.e setting it to a very = high value. Any input will > be highly appreciated. >=20 > Thanks a lot in advance. >=20 > Arup > ---------------------------------------------------------------- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > ---------------------------------------------------------------- > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx > put 'unsubscribe' in the subject line. > -- > Archives are at //www.freelists.org/archives/oracle-l/ > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html > -----------------------------------------------------------------=20 =3D=3D=3D=3D=3D Connor McDonald Co-author: "Mastering Oracle PL/SQL - Practical Solutions" - available = now web: http://www.oracledba.co.uk web: http://www.oaktable.net email: connor_mcdonald@xxxxxxxxx "GIVE a man a fish and he will eat for a day. But TEACH him how to fish, = and...he will sit in a boat and drink beer all day" =09 =09 =09 ___________________________________________________________ BT Yahoo! Broadband - Free modem offer, sign up online today and save = =A380 http://btyahoo.yahoo.co.uk ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------