Re: Turning off DML commit when session is exited or disconnected
Date: Thu, 18 Dec 2008 06:49:50 -0800 (PST)
On 18 dec, 15:12, Cristian Cudizio <cristian.cudi..._at_yahoo.it> wrote:
> On 18 Dic, 14:04, sybrandb <sybra..._at_gmail.com> wrote:
> > On 18 dec, 12:28, oracle user <rcl..._at_gmail.com> wrote:
> > > If i issue a DML statment in oracle database from sqlplus session
> > > (where autocommit is off by default ) and then 'exit' or 'disc' the
> > > session without explicitly commiting the DML ,the DML gets commited .
> > > Is it possible to turn off this default behaviour.
> > > Thanks in Advance
> > It is NOT possible.
> > How would it be? By design, your transaction ends by exiting Oracle.
> > It is a feature of the database, not of sql*plus.
> > If you don't want to commit your transaction, you issue rollback.
> > This won't get you RSI.
> > --
> > Sybrand Bakker
> > Senior Oracle DBA
> Well, i've to admit that this for me is a surprise. I've always used
> explicit commit or rollback
> but i've never knew that exiting or disconnecting from sqlplus
> transaction gets automatically
> committed. It is true that this behaviour cannot be changed, but it
> is a feature
> of SQL*Plus (http://download.oracle.com/docs/cd/B19306_01/server.102/
> If you kill a session, oracle rollbacks any changes.
> Cristian- Tekst uit oorspronkelijk bericht niet weergeven -
> - Tekst uit oorspronkelijk bericht weergeven -
It is NOT a feature of sql*plus. It is a feature of Oracle. It applies to anything connecting to Oracle, leaving with a proper exit command.
-- Sybrand Bakker Senior Oracle DBAReceived on Thu Dec 18 2008 - 08:49:50 CST