Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: help! cannot drop a table!

Re: help! cannot drop a table!

From: <ddf_dba_at_my-deja.com>
Date: 2000/07/05
Message-ID: <8jvhg4$a36$1@nnrp1.deja.com>#1/1

In article <8ju7fh$cft$1_at_nnrp1.deja.com>,   wy_at_fudan.edu wrote:
> 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.
>

Have you queried V$OPEN_CURSOR to see what is "running"?

--
David Fitzjarrell
Oracle Certified DBA


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US