Flashback table/drop: possible until... ?

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 Received on Fri Oct 21 2005 - 13:17:06 CDT