Path: news.easynews.com!easynews!news.he.net!chekhov.conxion.net!news.oracle.com!not-for-mail Sender: cjones@iron2-au Newsgroups: comp.databases.oracle.misc Subject: Re: SQL/Plus and autocommit References: From: Christopher.Jones@oracle.comX Message-ID: Lines: 20 User-Agent: Gnus/5.09 (Gnus v5.9.0) Emacs/21.2 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Date: 08 Jul 2002 12:37:07 +1000 NNTP-Posting-Host: 140.83.23.8 X-Trace: news.oracle.com 1026096007 140.83.23.8 (Sun, 07 Jul 2002 19:40:07 PDT) NNTP-Posting-Date: Sun, 07 Jul 2002 19:40:07 PDT Xref: easynews comp.databases.oracle.misc:83913 X-Received-Date: Sun, 07 Jul 2002 19:35:02 MST (news.easynews.com) Ken Denny writes: > "Matthias Wirtz" 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.