, some consistent lookups in a
> rollback segment was just deallocated by optimal, just before you got
> there - the database engine has no problems finding the data, they are
> there, well preserved in a deallocated rollback segment.
Are you sure about that? That is contradict to my experience. I
understand that the info is still there. However Oracle will use a
block that does not belong to the segment anymore? I definitely need
proof for this claim. If this is true, you should have no trouble get
data back right after you truncate a table as long as nobody else use
the space (Oracle can just use similar mechanism)! Of course you can
say flash back query for 9i, but that is different story.
Unfortunately I do not have a testing database now.
Received on Tue Feb 19 2002 - 11:47:06 CST
