Is your sa account granted the dba role?
--
Niall Litchfield
Oracle DBA
Audit Commission UK
"kush" <kdhakal_at_eline.com> wrote in message
news:QQS%5.2501$1%2.109454_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 Wed Dec 20 2000 - 04:12:28 CST
