Home » SQL & PL/SQL » SQL & PL/SQL » commit
commit [message #274295] Mon, 15 October 2007 07:45 Go to next message
ddkdhar
Messages: 68
Registered: February 2007
Member

I have a table A in one database(d1) and table B in another database(d2).
i connected to first database(d1) .
from this iam updating table B in another database(d2).
if i used rollback after update statement what statemnts are rolled back ( in d1 database or d2 database) ,
Re: commit [message #274297 is a reply to message #274295] Mon, 15 October 2007 07:47 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
Try it and report back to us.
Re: commit [message #274302 is a reply to message #274295] Mon, 15 October 2007 07:53 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Have a look at Database Concepts and read about transactions.

Regards
Michel
Re: commit [message #274787 is a reply to message #274295] Wed, 17 October 2007 02:41 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Quote:

if i used rollback after update statement what statemnts are rolled back ( in d1 database or d2 database)

The current database in which you are issuing the command.

select instance from v$thread;
Re: commit [message #274801 is a reply to message #274787] Wed, 17 October 2007 03:12 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Have a think about that answer.
If you rollback your transaction, and it only rolled back the part of it on your instance, what would happen to the transactions on the other instance?
Would they commit without an explicit commit, orwould they just hang there until you disconnected?
Previous Topic: SQL Query doubt
Next Topic: how can open sqlnavigator with vb 6
Goto Forum:
  


Current Time: Sat Dec 03 09:54:44 CST 2016

Total time taken to generate the page: 0.06144 seconds