Re: SQL/Plus and autocommit

"Matthias Wirtz" <Matthias.Wirtz_at_epost.de> wrote in 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.

I don't believe that is what autocommit does. I believe autocommit does an automatic commit when you end sqlplus if there are uncommitted updates, but not a commit after every update.
>
> 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.

-- 
Ken Denny
http://www.kendenny.com/

Know the rules well, so you can break them right.