Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL/Plus and autocommit
Ken Denny <ken_at_kendenny.com> writes:
> "Matthias Wirtz" <Matthias.Wirtz_at_epost.de> wrote in
> > 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.
Matthias is correct. See http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/server.920/a90842/ch13.htm#1012156
Chris
-- Christopher Jones, Oracle Corporation, Australia.Received on Sun Jul 07 2002 - 21:37:07 CDT