How will you force database to use particular rollback segment

Answered by: Lachi on 2005-06-08 07:28:04

For perticular transaction Alter system set rollback segment 'name';

For database, we can set in pfile. Rollback_segment='name'

Interview Candidate
Jun 13th, 2005
2
2165

First
Prev
Next
Last

Showing Answers 1 - 2 of 2 Answers

Lachi

Jun 8th, 2005

For perticular transaction Alter system set rollback segment 'name';
For database, we can set in pfile. Rollback_segment='name'

Lakshminarayan.

Jun 13th, 2005

In above answer one correction is there,

For perticular transaction we can use fallowing syntax.

>set transaction use rollback segment 'name'