Re: error pinning a package

From: Rene Nyffenegger <rene.nyffenegger_at_gmx.ch>
Date: 10 Aug 2004 09:48:37 GMT
Message-ID: <slrnchh6fb.3ro.rene.nyffenegger@zhnt60m34.netarchitects.com>

In article <opschh0wru3d8uqx_at_shostakovich.dizwell.com>, Howard J. Rogers wrote:
> On 9 Aug 2004 13:40:02 -0700, Thomas <manojthomas_at_gmail.com> wrote:
>

>> 13:38:39 SQL> show user
>> USER is "SYS"
>> 13:38:50 SQL>  execute dbms_shared_pool.keep('SYS.STANDARD','P');
>> BEGIN dbms_shared_pool.keep('SYS.STANDARD','P'); END;
>>
>>       *
>> ERROR at line 1:
>> ORA-06550: line 1, column 7:
>> PLS-00201: identifier 'DBMS_SHARED_POOL.KEEP' must be declared
>> ORA-06550: line 1, column 7:
>> PL/SQL: Statement ignored
>>
>>
>> Elapsed: 00:00:00.00

>
>
> Try running catspool.sql first. Found in the usual place: Oracle_Home,
> rdbms, admin.
>
> Needed to create DBMS_SHARED_POOL.
>
> Regards
> HJR
IMHO, that would be dbmspool.sql. Neither 9iR2, nor 10g have a catspool.sql (at least not on my system).

Rene

-- 
  Rene Nyffenegger
  http://www.adp-gmbh.ch/

Received on Tue Aug 10 2004 - 04:48:37 CDT