Hi
It is missing an object.
> ('ACL.HR_CTX' must be declared )
this type of error means you do not have the right
previllages, try compling under user sys or internal.
Reza
--- Cherie_Machler_at_gelco.com wrote:
> 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,
>
> Cherie
>
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author:
> INET: Cherie_Machler_at_gelco.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Do You Yahoo!?
Thousands of Stores. Millions of Products. All in one Place.
Received on Wed Nov 08 2000 - 02:40:15 CST
