Re: help! cannot drop a table!

I have change open_cursors to 500,but it doesn't work! and The table is Empty;
Is there Oracle datadictionary in inconsistent state. :(.

In article <962719468.29395.2.pluto.d4ee154e_at_news.demon.nl>,   "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:
> 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.
>
>

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