Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL/Plus and autocommit

Re: SQL/Plus and autocommit

From: s.kapitza <skapitza_at_volcanomail.com>
Date: 6 Jul 2002 00:29:24 -0700
Message-ID: <26703915.0207052329.4c1e6870@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US