Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Getting PLS-00904 when trying to compile (even as sysdba)
In article <2dec747a.0410070331.28068791_at_posting.google.com>,
Hans.Wijte_at_mail.ing.nl says...
> Marc Eggenberger <marc.eggenberger_at_remove.itc.alstom.com> wrote in message news:<MPG.1bcc71ed5f7f31c989687_at_iww.cacti.ch.alstom.com>...
[...]
> Otherwise, because the AQ objects are created in both the SYS and SYSTEM
> schemas, it is generally best (IF possible) to de-install AQ with the script
> catnoqueue.sql and ,after that, reinstall AQ by running the catqueue.sql
> script; these scripts are located in the $ORACLE_HOME/RDBMS/ADMIN directory
>
> Both scripts (if you're willing to run them, that is) must be run as SYS
Thank you very much, this solved my problem.
-- mfg Marc EggenbergerReceived on Mon Oct 11 2004 - 07:06:14 CDT