Re: Delete of child-entry locks father-table

HerbertMue wrote:

> Primarily we are using Oracle 9.2.0.1.
> And this problem occurrence at Oracle 9i.
> But we are also using 8.1.7 (there I have not tested this feature so
> far)
>

You do realize that you are running years-old software. Oracle dropped support for both of these versions years ago and will desupport ALL of 9i come Jul-2007.   Upgrade to something more current. It still boggles my mind how you can run your business on stuff this old - I guess you and your management care very little for your data.

 From Metalink:
Support Status

     For details of 9.2.0 desupport dates see the Lifetime Support Policy
     Note that Premier Support for 9.2 ends July 2007
     9.2.0.8 Current (terminal) 9.2 Patch Set

-- 
Michael Austin.
Database Consultant