Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Acquiring lock on table Partitions

sreenivas.g.gaddam-OracleMar 21 2022 — edited Mar 21 2022

Hi all
We have a requirement that we want to store data into a single schema,
e.g
assume from multiple departments/partitions(dept-id as partition-key)
there will be parallel updates on the same table from various depts, is there a way to lock the partition independently, without locking the entire table
will the locking partition implicitly lock the entire table?
Thanks for your time.

Comments
Post Details
Added on Mar 21 2022
5 comments
457 views