Flashback table/drop: possible until... ?

Giganews Newsgroups
Subject: Flashback table/drop: possible until... ?
Posted by:  Spendius (spendi…@muchomail.com)
Date: 21 Oct 2005

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

Replies