Re: rollback segment not big enough

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 - 19:35:32 CDT