OraFAQ Forum: Server Administration » Does insert operation in table uses rollback segment

Home » RDBMS Server » Server Administration » Does insert operation in table uses rollback segment

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Does insert operation in table uses rollback segment [message #56505]

Fri, 04 April 2003 05:40

Manish tiwari
Messages: 6
Registered: April 2003

Junior Member

Hi all,

I want to know if there is any roll of rollback segment in case of insertion operation in the table ......if yes can any body explain me how does it come in use ?

Manish

Report message to a moderator

Re: Does insert operation in table uses rollback segment [message #56512 is a reply to message #56505]

Fri, 04 April 2003 07:54

Anand
Messages: 161
Registered: August 1999

Senior Member

Whenever you do any DML operation ( INSERT, UPDATE , DELETE), Oracle takes an image/copy of the old data and stores in the rollback segments. That what rollback segments are used for. So, when you try to INSERT new data, old data goes to the rollback segment. Once you COMMIt the changes, new data is written permanently to the table and old data is discarded. However, the data in the rollback segments are not automatically flushed out. When a new transaction requests space in the rollback segments, old data are automatically flushed out of the rollback segments.
Incase you do a ROLLBACK, the old data is copied back from the rollback segments to the data blocks and the new data is discarded.

Whenever you INSERT, DELETE or UPDATE, old data will be stored in the rollback segments.

Hope it's clear.

Report message to a moderator

Previous Topic:	all_tab_histograms
Next Topic:	moving data from an oracle 7 db to a 9i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Dec 28 23:55:58 CST 2024