| oracle update [message #295779] |
Wed, 23 January 2008 07:23  |
jinga
Messages: 116
Registered: January 2003
|
Senior Member |
|
|
my table test_rep has 5 columns.
rep_no
col1
col2
col3
col4
col1 and col2 are updated by one subsystem and col3,col4 as well as insert into this table is done by another subsystem. Updates to this table can initiate from both of these subsystems at the same time.
Would there be any locking issue?
Ananthi
|
|
|
|
| Re: oracle update [message #295780 is a reply to message #295779] |
Wed, 23 January 2008 07:24  |
 |
Michel Cadot
Messages: 68761
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Only one session can update a row at a given time.
Or if you prefer, 2 sessions can't update the same row at the same time.
Or once a session updated a row nobodby can update it until the first session commits or rolls back.
Regards
Michel
[Updated on: Wed, 23 January 2008 07:26] Report message to a moderator |
|
|
|
| Re: oracle update [message #295784 is a reply to message #295779] |
Wed, 23 January 2008 07:33 |
jinga
Messages: 116
Registered: January 2003
|
Senior Member |
|
|
|
so, as long as the sessions ( initiating from both subsystems) take care of commit/rollback, there should not be any locking problem. Am i correct?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
