Re: Oracle blocks

>>3. Does Oracle put the whole original block into the undo segment and
>>create a duplicate of that block in the undo segment with the potential
>>row data changed for an update statement (2 full blocks - one with and
>>one without the results of the update statement) until commit time?
>>

>
> Yes, I think you mean the rollback.

Jim,

Thanks for the info. Yes, I did mean rollback. I used the term undo segment becasue the OCP study guide I'm reading has a dozen sidebars about how undo segments are the replacement for rollback segments and to treat the terms undo and rollback as the same thing, although I think the actual way undo segments in an undo tablespace work is a bit different than the way rollback segments did (I think undo is just a normal segment with extents being allocated and deallocated without a wraparound reuse (like redo logs)) but that's just a guess, I've read nothing specific about it.

Paul Murphy Received on Mon Oct 27 2003 - 11:27:39 CST