Re: The light dawns - public synonym called SYS - how to drop?

"gazzag" <gareth@[EMAIL PROTECTED]
> wrote in message 
news:8b87e8ad-691d-49f9-8d04-16fee37af408@[EMAIL PROTECTED]
> On 3 Jul, 17:08, jeremy <jeremy0...@[EMAIL PROTECTED]
> wrote:
>>
>> Following sorted it out:
>>
>> 16:57:13 SQL> drop public synonym sys force;
>> drop public synonym sys force
>> *
>> ERROR at line 1:
>> ORA-04098: trigger 'XDB.XDB_PI_TRIG' is invalid and failed re-
>> validation
>>
>> Elapsed: 00:00:00.49
>> 16:57:26 SQL> alter trigger XDB.XDB_PI_TRIG disable;
>>
>> Trigger altered.
>>
>> Elapsed: 00:00:00.15
>> 16:57:28 SQL> drop public synonym sys force;
>>
>> Synonym dropped.
>>
>> Elapsed: 00:00:00.58
>> 16:57:32 SQL> alter trigger XDB.XDB_PI_TRIG enable;
>>
>> Trigger altered.
>>
>> Elapsed: 00:00:00.18
>>
>> After which everything was fine again.
>>
>> --
>> jeremy- Hide quoted text -
>>
>
> Ah, you beat me to it!  An interesting academic exercise
> nonetheless :)
>
> Cheers,
>
> -g

But what got potentially out of whack in the data dictionary by virtue of 
that trigger not running?

Terry Dykstra