Re: rollback segment not big enough

Thanks Young-chul.

Young-chul,Jun wrote:

> Hi :)
>
> You can use "set autocommit 100" on SQL*PLUS.
>
> If you want to use large rollback segment ,
> you can use "set transaction use rollback segment L_RBS".
>
> ycjun_at_hotmail.com
> OCP
>
> Zoran Kukoljac ÀÌ(°¡) <361DF8CC.C007650_at_home.com> ¸Þ½ÃÁö¿¡¼­
> ÀÛ¼ºÇÏ¿´½À´Ï´Ù...
> >Hi,
> >I am truing to delete a large number of row from one database table but
> >the statement fails with message:
> >"failed to extend rollback segment"
> >Is it possible to "turn off" rollback feature only for one statement or
> >session or to tell oracle to automatically commit after for example
> >every 100 deleted rows ?
> >
> >Thanks, Zoran
> >
> >
> >
Received on Thu Oct 08 1998 - 22:37:28 CDT