Spendius wrote:
> Hi,
> Has someone experienced how long a table or a drop table
> can be flashbacked without problems once you've made a
> mistake ?
> Let's you have a table occupying 3 extents:
> 1/ You delete records in the 2nd extent: for how long
> will you be able to flashback them (and how does
> Oracle know that it can still recover them, is there
> some kind of rows markers for this block somewhere) ?
> 2/ You drop this table, but don't notice it immediately.
> Then Oracle needs one of these 3 ex-extents (say because
> the file's reached its max. size) for another segment:
> let's say Oracle chooses what was the 3rd extent; then
> you notice you mistakenly dropped this table: can you
> *partly* recover it or is it really too late for the
> whole segment, whatever the number of extent(s) still
> "available" (i.e. not yet occupied by a rival segment) ?
>
> Thanks a lot.
> Sp
The maximum time is 100 years provided you have configured
your system appropriately.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Fri Oct 21 2005 - 16:10:04 CDT
