DBMS_SHARED_POOL not available. How to install DBMS_SHARED_POOL - ORA-04043


 
SQL> desc dbms_shared_pool
ERROR:
ORA-04043: object dbms_shared_pool does not exist

$sqlplus "/as sysdba"

SQL> @?/rdbms/admin/dbmspool

Package created.


Grant succeeded.


View created.


Package body created.
 







Post a Comment

And that's all there is to it!

If anyone has any other questions or requests for future How To posts, you can either ask them in the comments or email me. Please don't feel shy at all!

I'm certainly not an expert, but I'll try my hardest to explain what I do know and research what I don't know.

Previous Post Next Post