Re: DBMS_SHARED_POOL installation

From: <sjakobson_at_my-dejanews.com>
Date: Mon, 17 Aug 1998 18:20:24 GMT
Message-ID: <6r9s98$6er$1@nnrp1.dejanews.com>

DBMS_SHARED_POOL should be owned by SYS. Most likely, you are compiling it as SYSTEM. Drop DBMS_SHARED_POOL owned by SYSTEM (or any other user) and compile it as SYS.

Solomon Yakobson

In article <6r8sdu$upj$1_at_nnrp1.dejanews.com>, lalaina_at_my-dejanews.com wrote:
> Hello ORACLE guys ,
>
> I'm currently working on a heavy application that would need the use of
> DBMS_SHARED_POOL.KEEP package.
>
> But when I run the script prvtpool.plb (as described in the docs) , I receive
> error messages :
>
> -ORA-01933: cannot create a stored object using privileges from a role
>
> -LINE/COL ERROR
> -------- ---------------------------------------------------------
> 21/7 PL/SQL: SQL Statement ignored
> 21/48 PLS-00201: identifier 'X$KGLOB' must be declared
> 67/9 PL/SQL: SQL Statement ignored
> 72/14 PLS-00201: identifier 'SYS.V_$SQLAREA' must be declared
> 89/7 PL/SQL: Statement ignored
> 89/10 PLS-00364: loop index variable 'REC' use is invalid
>
> Does anyone know how can I solve those problems ?
>
> Many thanks in advance
>
> Lalaina
> Lalaina.rako_at_advalvas.be
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Mon Aug 17 1998 - 13:20:24 CDT