Re: help! cannot drop a table!

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