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 -> Getting PLS-00904 when trying to compile (even as sysdba)

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

From: Marc Eggenberger <marc.eggenberger_at_remove.itc.alstom.com>
Date: Tue, 5 Oct 2004 09:55:50 +0200
Message-ID: <MPG.1bcc71ed5f7f31c989687@iww.cacti.ch.alstom.com> 





Hi there.



System is Oracle 8.1.7.0.0 on Windows2000 SP4 ADV Server  with Oracle 
Fail Safe



I found several Packages in status invalid in the sys schema. I tried to 
compile them but I'm getting errors. For example when trying to 
recompile SYS.DBMS_AQADM I get an PLS-00904: insufficient privilege to 
access object SYSTEM.AQ$_QUEUES



I even tried to connect as sysdba. No luck. But sys has access to this 
table. 


Anyone knows what I am doing wrong here?



-- 
mfg
Marc Eggenberger


Received on Tue Oct 05 2004 - 02:55:50 CDT












Original text of this message













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