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

On Jul 3, 10:11 pm, "Terry Dykstra" <tddyks..._at_forestoil.ca> wrote:
> "gazzag" <gar..._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

Most probably nothing. XDB is optional, so are its triggers, including DDL ones. This particular trigger only handles drop/truncate of XMLType tables, so it should not affect DROP SYNONYM.

Regards,

   Vladimir M. Zakharychev
   N-Networks, makers of Dynamic PSP(tm)    http://www.dynamicpsp.com Received on Fri Jul 04 2008 - 14:28:31 CDT