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: Can't drop table!

Re: Help: Can't drop table!

From: Daniel A. Morgan <damorgan_at_exesolutions.com>
Date: Fri, 18 Jan 2002 22:31:07 +0000
Message-ID: <3C48A22A.BD39A3CB@exesolutions.com>


Look in the data dictionary view USER_DEPENDENCIES, ALL_DEPENDENCIES, or DBA_DEPENDENCIES. Daniel Morgan

FredM wrote:

> I'm getting this error when trying to drop a table:
>
> ORA-00604: error occurred at recursive SQL level 1
> ORA-04052: error occurred when looking up remote object
>
> Someone here mentioned having the same problem, but didn't post a fix
> (something about missing components and rebuilding??).
Received on Fri Jan 18 2002 - 16:31:07 CST

Original text of this message

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