Re: Manual flashback implementation

From: Andreas Necker <Andreas.Necker_at_isb-ag.de.nospam>
Date: Wed, 20 Nov 2002 17:25:54 +0100
Message-ID: <i2dgra.tvb.ln@ftp2.intern.isb-ka.de>

Hi,

Richard Kuhler wrote:
>
> I'm also not sure what you mean by "upgrade". This process will run on
> a 9.2 database so flashback is available. My problem is that there are
> numerous constraints on flashback that could cause it to not work. Many
> of my tests with it resulted in Oracle refusing to perform the flashback
> query I requested. That is not acceptable. I must have a 100%
> guarantee that nothing that is done to the database will prevent me from
> querying the data as it looked in the past. Is there some configuration
> that will fix this will absolute certainty?
>

Flashback gives no 100% guarantee.
When you execute a DDL staement your flashback data is gone. Oracle overwrites commited undo data when there is not enough free space for active transactions in your undo tablespace (->UNDO_RETENTION).

Ciao
Andreas Received on Wed Nov 20 2002 - 10:25:54 CST