Help - Search - Members - Calendar
Full Version: Oracle Locking
Oracle DBA Forums > Oracle > Oracle Forum
Mohan85
Dear fnds,

1. Is it possible to lock a row in Oracle and unlock in a different session?
2. And if yes what is the command?
3. Also is there any command to lock a particular rows in the table???


Please help me.... ph34r.gif


Thanks,
Mohan unsure.gif
burleson
Hi Mohan,

Here is an overview of Oracle row level locking:

http://www.dba-oracle.com/t_locks_row_level_locking.htm


>> Also is there any command to lock a particular rows in the table???

What kind of lock?

You can set lock with many commands, like "select for update"

http://www.fast-track.cc/t_easyoracle_pl_s..._for_update.htm
SteveC
1. yes
2. alter system kill session 'sid,serial#';
3. see above
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.