Re: help! cannot drop a table!

From: <cnwy_at_my-deja.com>
Date: 2000/07/09
Message-ID: <8ka3qc$ul6$1@nnrp1.deja.com>#1/1

SQL> drop user hrd cascade;
 drop user hrd cascade
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1 ORA-01000: maximum open cursors exceeded

SQL> select * from v$open_cursor;

SADDR          SID USER_NAME                      ADDRESS  HASH_VALUE

SQL_TEXT

-------- --------- ------------------------------ -------- ---------- --
----------------------------------------------------
215C1A68        10 SYSTEM                         21E35158  4.066E+09

select * from v$open_cursor

>
> Have you queried V$OPEN_CURSOR to see what is "running"?
>
> --
> David Fitzjarrell
> Oracle Certified DBA
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sun Jul 09 2000 - 00:00:00 CDT