-
Autocommit
Dear Members,
I set Autocommit off on my Database but when i exit the sqlplus without running commit command for any SQL. those records surprisingly saved. is any body has any solution? if yes then please reply.
-
Expected behaviour. EXIT is considered normal exit and since you have not rolled back, SQL Plus implicitely commits
Either leave SQL Plus using QUIT not EXIT or just rollback before leave
Cheers
-
Dear Bore, Actually i have a central database on 10g and it is accessed by differnt user at different Locations by Lease line. when ever the connectivity is down by any unavoidable reseaon records have been saved without passing commit command by user via Form of from SQL.
-
-
Dear koustubh,
[q]
but when i exit the sqlplus without running commit command for any SQL. those records surprisingly saved.
[/q]
Is that what u asked?
What u ask now seems pretty unusual and I suppose some client commits somewhere implicitly
Cheers
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|