Re: help! cannot drop a table!

Currently 500 open_cursors is more like the acceptable minimum. 200 is too low.
The cursors you are getting complaints about are created by the kernel on your behalf in order to assist you with dropping. You might have an extreemly fragmented table, tablespace or a datadictionary (saw this issue before in those instances).

Hth,

Sybrand Bakker, Oracle DBA

<wy_at_fudan.edu> wrote in message news:8jsm80$apa$1_at_nnrp1.deja.com...
> Open Cursors is set to 200.
> This table have no dependences with other objects.
> when I drop the user,it raise the same error.
>
> In article <3961947E.49A1CC9B_at_ina.hr>,
> deana strbevski <deana.strbevski_at_ina.hr> wrote:
> > is there any dependences on table ?
> > Although, you can increase OPEN_CURSORS parameter in
 init.ora ,shutdown and
> > restart your database.
> >
> > 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 Tue Jul 04 2000 - 00:00:00 CDT