Re: SQL/Plus and autocommit

SQL> set autocommit off
SQL> insert into a values (2);

1 row created.

SQL> r
  1* insert into a values (2)

1 row created.

SQL> set autocommit on
SQL> r
  1* insert into a values (2)

1 row created.

Commit complete.
SQL> r
  1* insert into a values (2)

1 row created.

Commit complete.
SQL> regards
s.kapitza

Ken Denny <ken_at_kendenny.com> wrote in message news:<Xns9242BAEEBE368kendenny_at_65.82.44.7>...
> "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.
Received on Sat Jul 06 2002 - 02:29:24 CDT