Re: Unable to Drop the Package

From: Andy Hardy <Andy.Hardy_at_camk.demon.co.uk>
Date: Tue, 26 Jan 1999 09:06:50 +0000
Message-ID: <FI7fNAAqWYr2MwpZ@camk.demon.co.uk>

In article <19990122165835.23381.00001831_at_ng-cg1.aol.com>, GANDHI JAY <gandhijay_at_aol.com> writes
>ORA-04021: timeout occurred while waiting to lock object
This should indicate that the package is being run at the time that you tried to drop it.

You could check the dba_jobs_running (check the name!) view to see whether it is running, if it is not then you may need to stop and restart your database to get the locks back.

Andy
--
Andy Hardy
Senior IT Systems Engineer, Alstom Automation Tel: +44 1908 696200
Fax: +44 1908 696225

---

Opinions are mine and do not necessarily reflect those of Alstom Automation Received on Tue Jan 26 1999 - 03:06:50 CST