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.
> 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
> create a table but not drop it.
> Any help is appreaciated. Thanks.
> >Look in the data dictionary view USER_DEPENDENCIES, ALL_DEPENDENCIES, or
> >Daniel Morgan
> >> 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??).