Re: DBMS_SHARED_POOL.KEEP Question

Hello,

It seems you don't have objects in the oracle dictionnary !

Have you compile the catalog.sql , catproc.sql ??

Take care all this catalog and package must be compiled with internal or sys user !!

Regards

"kush" <kdhakal_at_eline.com> a écrit dans le message news: SRS%5.2503$1%2.109448_at_sjc-read.news.verio.net...
> Hi all, I am trying to use DBMS_SHARED_POOL.KEEP package to keep some of
> pl/sql objects. for this I tried to run dbmspool.sql, but it gave me
> follwing error
> Package created.
> Grant succeeded.
> from dba_object_size
> *
> ERROR at line 4:
> ORA-00942: table or view does not exist
> Warning: Package Body created with compilation errors.
>
> After getting this, looked to me that package is created, I tried to use
> DBMS_SHARED_POOL.KEEP but gave me this error
> ERROR at line 1:
> ORA-04068: existing state of packages has been discarded
> ORA-04063: package body "SA.DBMS_SHARED_POOL" has errors
> ORA-06508: PL/SQL: could not find program unit being called
> ORA-06512: at line 1
>
> Any ideas? do I need to run any other .sql before running dbmspool.sql, if
> not why I was getting compilation error and what is the solution?
> Thanks in advance.
>
> kush
>
>
>
>
Received on Fri Dec 22 2000 - 00:17:12 CET