Re: rollback segment keeps growing

You know you have to commit or rollback after every insert, update or delete?

Erik

blop_at_my-deja.com wrote in message <82lj4j$1vg$1_at_nnrp1.deja.com>...
>Hi,
>
>I have a simple perl script that updates about 1 meg of datas in an
>oracle 8.1.5 DB.
>
>Each time I run the script, the datas are updated indeed but I noticed
>the rollback segment grows one meg more and is never purged even after
>restarting the DB !
>Eventually I get a "can't extend rbs" error and of course setting it to
>auto extend wouldn't be a solution as it would end up by filling the
>entire hard drive.
>
>So how can I purge that RBS and how can I prevent it from keeping
>outdated datas after the transaction has ended ?
>
>Thanks for any help,
>
> Arnaud.
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Wed Dec 08 1999 - 07:11:59 CST