Re: Dropping tables

From: Phil Cook <pncook_at_worldnet.att.net>
Date: 1998/01/23
Message-ID: <6a8vob$2qv@bgtnsc02.worldnet.att.net>#1/1

Check the view dba_ddl_locks, I've seen locks there that don't show up in v$lock. Also, see if anyone is accessing tables that are connected to this table, see v$access.

Another method is to drop the constraints and triggers and then do your drop.

Also try bouncing the instance, clearing the sessions, and then perform the drop(s).

Phil Cook
Certified Oracle DBA

> Thanks in advance.....
>
> Roy.
>
>
>
Received on Fri Jan 23 1998 - 00:00:00 CST