Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

auto commit issue

absriramJul 9 2009 — edited Jul 10 2009
Hi All,
I am facing some issue with my database. I am not sure how to avoid this.
Database is 10g.

I created a table and inserts some data into that and exit the session with out any commit or rollback and logged in again all the rows I was inserted committed automatically even my set autocommit off. Please help me. This makes my DB as inconsistency.

see the below statements:
=======================
SQL> set autocommit off
SQL> create table a(a number);

Table created.

SQL> insert into a values(1);

1 row created.

SQL> insert into a values(2);

1 row created.

SQL> exit
=======================
Again logged in and checked:-
SQL> select * from a;

A
----------
1
2
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 7 2009
Added on Jul 9 2009
11 comments
2,977 views