Re: DBMS_SHARED_POOL.KEEP Question

No I haven't run catalog.sql nor catproc.sql. Do I need to? I am running dbmspool.sql as dba not as sys. thanks.

kush
<jdarrah_co_at_my-deja.com> wrote in message news:91p56r$12h$1_at_nnrp1.deja.com...
> Have you run catalog.sql and catproc.sql? Are you running dbmspool.sql
> as SYS?
>
> In article <yRS%5.2502$1%2.109281_at_sjc-read.news.verio.net>,
> "kush" <kdhakal_at_eline.com> wrote:
> > 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
> >
> >
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Tue Dec 19 2000 - 20:35:56 CST