What you're seeing is an implicit commit !To prevent it - before exiting the
session , issue ROLLBACK; then EXIT
vikas
-Original Message-
Sent: Tuesday, June 05, 2001 12:30 AM
To: Multiple recipients of list ORACLE-L
Dear DBA Gurus,
Can you tell me how to prevent oracle
Hi Ranganath,
There are several situation for oracle to commit.
one of them of course you type 'commit;' manually
others can be :
when checkpoint occur
when switch redo log occur
when LRU function need to find space in your SGA
when shutdown normal (am I wrong ?, Oracle rollback or
set autocommit off (in sqlplus)
and i'm not sure but cant you set this to be the default to happen in some
glogin.sql file ?
-Original Message-
Sent: 05 June 2001 08:30
To: Multiple recipients of list ORACLE-L
Dear DBA Gurus,
Can you tell me how to prevent oracle from
Ranganath,
AFAIK, this can't be done. A normal exit has an
implied commit. Perhaps someone else can suggest a
way to do this programmatically.
HTH,
-- Anita
--- Ranganath K [EMAIL PROTECTED] wrote:
Dear DBA Gurus,
Can you tell me how to prevent oracle from
committing a
Alternatively, you can also use QUIT.
Stephane Faroult
What you're seeing is an implicit commit !To prevent it - before exiting the
session , issue ROLLBACK; then EXIT
vikas
-Original Message-
Sent: Tuesday, June 05, 2001 12:30 AM
To: Multiple recipients of list ORACLE-L
Dear DBA
Sinardy,
I am afraid that you are under a number of misconceptions, and confusing writing to
disk and commiting. The former is something physical, and the later more logical,
althought it is also accompanied by a physical write.
Whenever a disk flush occurs, the 'state' of your transaction
Hi,
If you set autocommit off it will rollback any uncommitted transactions by
default when you exit SQL*Plus.
regards,
Mike Hately
Oracle DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858)
Can you tell me how to prevent oracle from
committing a transaction unless unless
I explicitly commit it.
To do what you are asking, exit sql*plus with the command:
exit rollback
This will exit you from sql*plus and it will prevent Oracle from committing
a transaction unless you have
Hi DBA Gurus,
The following soultion worked for me: Exit Rollback. My special thanks to
Marco Rooy van and Ray O'Brien for providing the solution.
Regards,
Ranganath
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ranganath K
INET: [EMAIL PROTECTED]
Wow, you're right.
Let this be a warning to you all; this is what happens to your brain when you
mess with DB2. Just say no kids.
= )
Thanks,
Mike
Hi Mike,
I was also thinking so. But it doesn't do so. Setting autocommit
off will
implicitly commit all your transactions
Keep in mind that if at any point you issue any DDL command, a commit is
automatically performed. For example, if you open a SQL*Plus session,
insert a few records, then do an alter table ..., those records will be
committed.
Just a thought...
Jim
--
Jim Hawkins
Lead SAPR/3 Oracle
to:
com Subject: Re: RE: How to prevent oracle
from committing a transaction
Wait a minute here.
Why would oracle do a commit on your transaction
just because it needs to do a checkpoint, logfile switch, or shutdown?
What if errors occur during validation?
Do you think Oracle will commit the data anyways?
--
Please see the official ORACLE-L FAQ:
:
root@fatcity.Fax to:
com Subject: Re: RE: How to prevent oracle
from committing
Commit will take place after any DDL statement. Besides that, Oracle
Complete Reference by George Koch and Kevin Loney states that commit will
occur after you execute the following commands: exit, quit, and even
connect.
If you are worried about unmanaged commits after the sudden instance crash
I did not try it but what if we have a trigger on logoff which will raise
application error.
Alex Hillman
-Original Message-
Sent: Tuesday, June 05, 2001 5:05 AM
To: Multiple recipients of list ORACLE-L
Ranganath,
AFAIK, this can't be done. A normal exit has an
implied commit.
No Oracle doesn't do commits for checkpoint, log switch or shutdown normal.
It will only commit data explicitliy (using the commit command) or implicitly (DDL).
SQL*PLUS by default auto commits for you if you just exit after doing some DML.
But you can turn that off.
Richard Ji
[EMAIL
to:
root@fatcity.Subject: RE: How to prevent oracle from
committing a transaction?
com
18 matches
Mail list logo