The auto commit will only commit the pending transactions on exit... not
once for each insert
"Matthias Wirtz" <Matthias.Wirtz_at_epost.de> wrote in message
news:ag51an$iq56r$1_at_ID-151394.news.dfncis.de...
> 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.
>
> --
> Matthias Wirtz - Karlsruhe
>
Received on Fri Jul 05 2002 - 22:17:34 CDT
