ORA-06550 – DBMS_SHARED_POOL


when i run DBMS_SHARED_POOL.KEEP, i got this error message

ORA-06550: line 2, column 4:
PLS-00201: identifier ‘DBMS_SHARED_POOL.KEEP’ must be declared

after i search net, the solution is to run the script dbmspool.sql located in ORACLE_HOME\RDBMS\admin as sysdba

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: