Re: Use Large Rollback Segment

>
> At 08:51 AM 2/2/96 +0800, Jason Luk Chi Fai declared:
> >According to Oracle Manual, we should use a small rollback segment for
 optimal
> > performance. So we
> >use several rollback segment. The first four rollback segments are small ones
> > and the last one is
> > a large one. But when we perform a massive update, it somestimes fail with a
> > message that Oracle
> > cannot extend the first four small rollback segments and fail to perform the
> > updates. It seems
> >that it cannot use the last large rollback segment.
> >
> >Could anybody have any ideas about that ?
> >
>
> You don't say what version you are running, but I recently ran into this
> running some scripts against my v. 7.1 database. To solve my problem I
> created one very large rollback segment and use the "set transaction use
> rollback segment <segment name>" command just prior to running my large
> update/delete scripts.
>
> HTH
>
> Beverly White
> bjwhite_at_ucsd.edu
> Phone: 619/622-5866 Fax: 619/622-0782
> "I've always been intrigued by women named BJ" --Fox Mulder
>

Dear White

        When u want to use a particular rollback segment in a transaction user folling statement

        set transaction
        use rollback segment <rollback segment name>
        update table1
        set col1='value1'
        where = <condition>;

                                        avnish (TUL, INDIA>