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

"gazzag" <gareth_at_jamms.org> wrote in message news:8b87e8ad-691d-49f9-8d04-16fee37af408_at_e39g2000hsf.googlegroups.com...
> On 3 Jul, 17:08, jeremy <jeremy0..._at_gmail.com> 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 Received on Thu Jul 03 2008 - 13:11:03 CDT