Re: help! cannot drop a table!

SQL> select count(*) from user_extents where segment_name='INCARDDAYSTAT';

 COUNT(*)

        1

SQL> select * from INCARDDAYSTAT;

no rows selected

SQL> truncate table INCARDDAYSTAT;

Table truncated.

SQL> drop table INCARDDAYSTAT;
drop table INCARDDAYSTAT

           *
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1 ORA-01000: maximum open cursors exceeded

sys user
SQL> r
  1* select statistic#,value from v$sesstat where statistic# in (2,3) and sid=18

STATISTIC# VALUE
---------- ---------

         2      1081
         3         0

in hrd
SQL> r
  1* drop table INCARDDAYSTAT
drop table INCARDDAYSTAT

           *
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1 ORA-01000: maximum open cursors exceeded

in sys
SQL> r
  1* select statistic#,value from v$sesstat where statistic# in (2,3) and sid=18

STATISTIC# VALUE
---------- ---------

         2      1586
         3         0

In article <8kas7o$ef7$1_at_nnrp1.deja.com>,   satyam130268_at_my-deja.com wrote:
> You wrote that the table is empty.
> Can you do
> select count(*) from user_extents where segment_name='INCARDDAYSTAT';
> Is it very high ? If so, the table grew too large when all records are
> deleted. Try to truncate the table before dropping.
> I think you are connecting the session afresh before dropping table.
> You can select statistic#,value from v$sesstat where statistic# in
 (2,3)
> for your session when the drop table is issued and monitor the growth
> of Open cursors from another (DBA) session.
>
> Satyam J

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