Just catching up on my emails :)
Keep in mind that UNDO for LOBs is stored in the Block itself
(PCTVERSION) and not in UNDO segments. The rollback mechanism is
different where LOBs are concerned, and Oracle uses file blocks
containing data (rather than rollback/undo blocks) to provide
read-consistency (i.e. reconstruct prior-image from rollback data for
satisfying queries that started before the change). I believe this is
the cause of the problem...
--
John Kanagaraj <><
DB Soft Inc
Phone: 408-970-7002 (W)
** The opinions and facts contained in this message are entirely mine
and do not reflect those of my employer or customers **
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Mar 30 2007 - 19:00:04 CDT
