Home » SQL & PL/SQL » SQL & PL/SQL » oracle update
oracle update [message #295779] Wed, 23 January 2008 07:23 Go to next message
jinga
Messages: 115
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
jinga
Messages: 115
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?
Re: oracle update [message #295786 is a reply to message #295784] Wed, 23 January 2008 07:50 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't know what you mean with "locking problem", for me there never is locking problem only application one. Wink

If rows are not updated in the same order then you can have dead locks (which are application issues not RDBMS ones).

Regards
Michel


Previous Topic: Creating a Table and then match the field against a table (merged)
Next Topic: What is the difference between these 2 queries
Goto Forum:
  


Current Time: Sat Dec 10 03:20:42 CST 2016

Total time taken to generate the page: 0.11659 seconds