Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> DBMS_SHARED_POOL.KEEP Question
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 Tue Dec 19 2000 - 18:14:22 CST