As Daniel Morgan proposed below - see if there are any dependencies on
the table being drop - if there is one or more - ORACLE will not let you
drop the table - irrespective of grants.
"FredM" <fredmotta_at_centurytel.net> wrote in message
news:GQp28.20196$Xs4.4015748_at_feed.centurytel.net...
> I finished granting in these tables to DBA role and a special user, but
> still get the same error message. There must be something wrong if SYS
can
> create a table but not drop it.
> Any help is appreaciated. Thanks.
>
> Fred***
>
>
> >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 Sat Jan 19 2002 - 22:11:52 CST
