You need a larger shared pool. In the init.ora file shared_pool_size= You
have tostop and restart the database for it to take effect.
Jim
"Victor" <penpendisarapen_at_yahoo.com> wrote in message
news:e203374a.0206101650.1699564f_at_posting.google.com...
> Help!
>
> I received the following message while doing an update:
>
> ERROR at line 1:
> ORA-04045: errors during recompilation/revalidation of
> ELSC_TEST.SET_BOM_MOD_DATE
> ORA-04031: unable to allocate 4096 bytes of shared memory ("shared
> pool","update bom_detail
> set topic_...","PL/SQL MPCODE","BAMIMA: Bam Buffer")
>
> I've also received something similar when doing a "CREATE OR REPLACE
> TRIGGER" statement, and once in a while when logging in to sqlplus. We
> have a part-time DBA who I haven't been able to contact.
>
> Any thoughts? Thanks in advance.
>
> Victor
Received on Mon Jun 10 2002 - 22:02:57 CDT
