Re: Help: Can't drop table!

From: FredM <fredmotta_at_centurytel.net>
Date: Sat, 19 Jan 2002 18:22:02 -0800
Message-ID: <GQp28.20196$Xs4.4015748@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 - 20:22:02 CST