Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: help! cannot drop a table!
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
In article <8js2f3$sqb$1_at_nnrp1.deja.com>,
wy_at_fudan.edu wrote:
> I want to drop the table but fail.
> 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
>
> [ora8_at_server450 ora8]$ oerr ora 00604
> 00604, 00000, "error occurred at recursive SQL level %s"
> // *Cause: An error occurred while processing a recursive SQL
statement
> // (a statement applying to internal dictionary tables).
> // *Action: If the situation described in the next error on the stack
> // can be corrected, do so; otherwise contact Oracle Support.
>
> How should I do?
>
> Thanks a lots.
>
> 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