Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PLS-00201 Error on Migration to 10.2.0.3 on DBMS_SHARED_POOL

523938Aug 5 2007 — edited Aug 5 2007
Below is a procedure I am trying to compile and keep getting the error:

PLS-00201: Identifier 'SYS.DBMS_SHARE_POOL' must be declared.

I have run from the 10G 10.2.0.3 rdbms/admin directory:
catupgrd.sql, catalog.sql, catproc.sql and utlrp.sql and dbmspool.sql
all connected as : sys/xxx as sysdba. Below is the PL/SQL for the procedure I am trying to compile. Anyone see what I am doing wrong or what may be missing from the 10.2.0.3 database?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 2 2007
Added on Aug 5 2007
#general-database-discussions
1 comment
254 views