Re: Rollback segments and Inserts

From: <kvsraju_at_my-dejanews.com>
Date: Thu, 04 Feb 1999 10:56:47 GMT
Message-ID: <79budc$8g6$1@nnrp1.dejanews.com>

In article <36B506A5.4A2E_at_aus.hp.com>,
Frank_Magliozzi_at_aus.hp.com wrote:
> Can someone clear up an item for me regarding
> rollback segment use during insert operations.
>
> What BI blocks are entered into rollback segments
> when an insert is taking place ?
>
> Empty blocks when it can't insert the row into
> a block that has rows already?
>
> Thanks
>

I COULDN'T UNDERSTAND U'R QUESTION.
BUT WITH MY UNDERSTANDING I CAN ANSWER THIS LIKE WHEN U DO NEW INSERT THE VALUE WILL BE STORED IN THE DATA BLOCK OF TABLE. BUT CORRESPONDING TO THAT ROW A NUL WILL BE INSERTED IN THE ROLLBACK SEGMENT BLOCK.
IF IT IS NOT FINDING ANY SPACE IN ROLLBACK SEGMENT TO STORE THIS(null) ORACLE CANOT INSERT VALUES INTO THE TABLE EVENTHOUGH IT IS HAVING SPACE IN IT (table).FOR MORE CLARRIFICATION PLEASE SEND A MAIL TO ME

hope this helps u

rgds
kvsraju_at_usa.net

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Feb 04 1999 - 04:56:47 CST