Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: DBMS_SHARED_POOL.KEEP Question

Re: DBMS_SHARED_POOL.KEEP Question

From: kush <kdhakal_at_eline.com>
Date: Wed, 20 Dec 2000 19:00:10 GMT
Message-ID: <_k706.2605$1%2.115770@sjc-read.news.verio.net>

Thanks to all of you who answered. It has been solved now, the problem was, instead of running it as internal or sys I was running it as dba. kush
"Cong Tang" <Cong.Tang_at_ctbto.org> wrote in message news:20001220.133939.865250_at_CTBTO.ORG...
> Hello,
> The package and package body should be install under the SYS account:
>
> SVRMGR> connect internal
> SVRMGR> @$ORACLE_HOME/rdbms/admin/dbmspool.sql
>
> Make sure that the script to create package body
> $ORACLE_HOME/rdbms/admin/prvtpool.sql is called at the end of your
> dbmspool.sql. If not, you have to run this script to create the package
 body.
>
> For Oracle8i you can create an AFTER LOGON database trigger to
 automatically
> load large packages into the shared pool when the database is started.
>
> Cong
>
> kush 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
>
Received on Wed Dec 20 2000 - 13:00:10 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US