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

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 Received on Thu Jul 03 2008 - 11:21:34 CDT