OraFAQ Forum: Server Administration » Can an Oracle DML statement use many rollback segments?

Home » RDBMS Server » Server Administration » Can an Oracle DML statement use many rollback segments?

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

Can an Oracle DML statement use many rollback segments? [message #176433]

Thu, 08 June 2006 05:42

agostino_neto
Messages: 180
Registered: July 2005

Senior Member

Hi,
I would like to know if a single DML statement (insert or update for example) can use many rollback segment when there is not enough space in RS_01 for example will Oracle use RS_02 ?
Thanks for your response.
I am using 8.06 but interested for responses regarding later versions also.

Report message to a moderator

Re: Can an Oracle DML statement use many rollback segments? [message #176455 is a reply to message #176433]

Thu, 08 June 2006 06:24

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

No (as far as I know), but you may tell Oracle WHICH ONE to use, for example:

set transaction use rollback segment rlbk01;
update some_table set ... ;

Report message to a moderator