Hi Cherie,
Have you contacted Oracle on this? The OUTLN user gets created during
database creation. And according note# 1071358.6 on Metalink, it can not be
created on the fly.
> -----Original Message-----
> From: Cherie_Machler_at_gelco.com [SMTP:Cherie_Machler_at_gelco.com]
> Sent: Tuesday, November 07, 2000 9:26 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Where can I find source for CTXTRIGGER
>
> I accidentally dropped my OUTLN user. Now
> when I connect as system I get an error that trigger
> CTXTRIGGER is invalid. I tried compiling it but
> it has compilation errors. It is missing an object.
> ('ACL.HR_CTX' must be declared )
> I tried rerunning catalog and catproc as Metalink
> recommended. Still the same error. I can't
> find the catxxxx sql that builds this trigger. I grepped
> on $ORACLE_HOME/rdbms/admin but did not
> find CTXTRIGGER anywhere in the directory. Does
> anyone know what builds this trigger?
>
> Thanks,
Received on Tue Nov 07 2000 - 10:34:46 CST
