Database Software

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!

UL type lock on a table blocking all other users

296484Jan 15 2008 — edited Jan 17 2008

Hi,

We have a referential integrity constraint on a version enabled table, that refers to a non-version enabled table (highly active table..lots of inserts/updates). An insert into the version enabled table is causing a UL type lock and the non-versioned table is locked (literally the table is inaccessible) and we see blocking locks. How can I avoid this situation? Is there any OWM settings that will help me resolve this issue? I am using workspace manager version 10.2.0.4.2.

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 14 2008

Added on Jan 15 2008

#database-key-features, #workspace-manager

1 comment

3,972 views