Re: Removing Foreign Keys

In article <9qjrtsgon6mpk33imdc373jbctq623ur0p_at_4ax.com>,   NeedaHoliday wrote:
> i am trying to remove a foreign key and keep getting this message. Is
> there a way to force the DROP;
>
> ora-000054 Resource Busy and acquire with NOWAIT specified
>
> Thanks,
>

 Hi,

       The ora-00054 error comes when one tries to modify an object that

        has a lock on it.

        The table that you are trying to modify must be having a DDL

        or DML lock .

        You can check the locks through V$lock table. Further you can

        identify the objects that

        are currently locked and the sessions that are acceessing them

        through V$ACCESS table.

        once you identify the session that has a lock on the object you

        have to release the lock

        either by COMMIT or ROLLBACK .

        check whether there are indexes on the foreign key columns or

         not. If yes then Any DML on

        parent table will acquire only row locks on the index of the

         foreign key and no table level

          lock is required on the child table.It is preferable to use

          indexes on foreign keys.

-sanjeev.
 OCP. Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Oct 06 2000 - 17:02:08 CDT