SQL & PL/SQL

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!

MERGE's locking behaviour

NuerniMay 12 2009 — edited May 12 2009

Using 10gR2

I'd like to "replicate" from an old table table_a (containing some million of rows) to a new designed table table_b (not in use by anyone) several times during one day, but table_a is still in use by approx. 50 users concurrently.

Does MERGE from table_a to table_b lock the source-table (table_a) during execution? Are the users able to use table_a without being (dead-)locked?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 9 2009

Added on May 12 2009

3 comments

1,115 views