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
dbmspool.sql ... and for information on this package go to:
http://www.psoug.org
click on Morgan's Library
click on DBMS_SHARED_POOL
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Thu Aug 12 2004 - 21:49:09 CDT
