SQL/Plus and autocommit

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