Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Getting PLS-00904 when trying to compile (even as sysdba)

Re: Getting PLS-00904 when trying to compile (even as sysdba)

From: Marc Eggenberger <marc.eggenberger_at_remove.itc.alstom.com>
Date: Mon, 11 Oct 2004 14:06:14 +0200
Message-ID: <MPG.1bd495a2a0d7ce1b989689@iww.cacti.ch.alstom.com>


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 Eggenberger
Received on Mon Oct 11 2004 - 07:06:14 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US