Re: SQL/Plus and autocommit

On Fri, 5 Jul 2002 22:59:05 +0200, "Matthias Wirtz" <Matthias.Wirtz_at_epost.de> wrote:

>Hy,
>
>i encounter probs with the sql/plus function autocommit.
>
>I set autocommit on and did a lot of inserts like: INSERT INTO EMP
>(col1,col2) VALUES (val1,val2);
>
>I supposed that after each insert statement the sql/plus will do a commit.
>But i received a rollback error saying that my rollback segment is full.
>
>In my oppinion the rollback segement only needs to hold one insert
>statement. Because after each insert statement the rdbm received a commit
>an can reuse the rollback segement.
>
>Can anyone point out my missunderstanding? Thanks.

Without the exact error my assumption is you have a badly configured database, and you are indeed hitting an error after an indivdual INSERT.
Using autocommit is also considered VERY BAD practice, as you are creating mini-transactions.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Jul 05 2002 - 17:20:53 CDT