PIN_PACKS-TRIGGER-INVALID, DBMS_SHARED_POOL.KEEP must be declared 10g
March 5, 2014 Leave a comment
To resolve the issue, do the following:
1. Connect as SYSDBA
$sqlplus / as sysdba
2. Create DBMS_SHARED_POOL package , grant necessary privileges and create dba_keepsizes view.
@?/rdbms/admin/dbmspool.sql
3. Recompile the trigger
alter trigger PIN_PACKS compile;