In 9i, you can flashback to any point in time where the old data is
still in the UNDO tablespace. The UNDO_RETENTION parameter specifies
how long you would like to have UNDO retained, but if your UNDO
tablespace isn't large enough to accommodate the undo records that are
generated over that period, Oracle can remove records before
UNDO_RETENTION is hit.

If you are doing timestamp-based flashback, you are also limited to 5
days of uptime, since Oracle maintains the SCN to timestamp mapping
table only so long.

Justin Cave
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC

-----Original Message-----
From: Gray Geoff
[mailto:oracledba-ezmlmshield-x54840052.[Email address protected]
Sent: Thursday, March 03, 2005 12:43 AM
To: LazyDBA Discussion
Subject: flashback queries

.. make that flashback queries



Does anyone what determines how far back a flashback query can go?

Regards,

Geoff

Geoff Gray
technical consultant
energy and utilities
logicacmg






This e-mail and any attachment is for authorised use by the intended
recipient(s) only. It may contain proprietary material, confidential
information and/or be subject to legal privilege. It should not be
copied, disclosed to, retained or used by, any other party. If you are
not an intended recipient then please promptly delete this e-mail and
any attachment and all copies and inform the sender. Thank you.


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page