Increase your JAVA_POOL_SIZE and retry. Default is usually inappropriate,
I'd recommend having this value at 50 megs or more.
--
Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.
"Ray Teale" <ray_at_BLAHholly.com.au> wrote in message news:cspu8.1982$c_3.267928_at_ozemail.com.au...
> Hi All,
>
> I posted this question a while ago but didn't get any replies that I could
> see.
> It is still a problem for me so I'm posting again in the hope somebody can
> help.
>
>
> I was trying to do a full database export (Version 8.1.6.0.0 on Sun Sparc)
> of a fairly small database but got the following error message:
>
> . exporting referential integrity constraints
> . exporting synonyms
> EXP-00008: ORACLE error 4031 encountered
> ORA-04031: unable to allocate 4032 bytes of shared memory ("shared
> pool","oracle/aurora/rdbms/DbmsJavaSYS","joxlod: in ehe","ioc_allocate_pal")
> EXP-00000: Export terminated unsuccessfully
>
> .. after all the database users and tables had been exported, just at the
> time the system was ". exporting synonyms."
>
> Well I thought this was a bit strange for such a small database but I
> doubled the shared_pool_size, bounced the database and tried again. Same
> problem - it failed at the same spot.
> So I tried again - this time the shared pool was 15 times the original size
> but still the export failed at the same spot.
>
> So I checked the synonyms and found there are nearly 10000, most owned by
> PUBLIC and pointing to tables in SYS, and none created by me for my
> application.
> Couple of questions:
> 1. What are synonyms in the following format for (examples chosen at random
> below) and do I need them (there are lots) :
>
> SYNONYM_NAME TABLE_NAME
> ------------------------------ -----------------------------
> -
> /10076b23_OraCustomDatumClosur /10076b23_OraCustomDatumClosur
> /10322588_HandlerRegistryHelpe /10322588_HandlerRegistryHelpe
> /10739900_GenericURLDirContext /10739900_GenericURLDirContext
> /1079c94d_NumberConstantData /1079c94d_NumberConstantData
> java/security/KeyPairGenerator java/security/KeyPairGenerator
> java/security/MessageDigest java/security/MessageDigest
>
> 2. Would exporting synonyms really put that much of a strain on the shared
> pool? Why?
>
> OK .. so that was about four questions..
>
> Kindest Regards (and apologies for any formatting issues.)
>
> Ray Teale
>
>
>
Received on Mon Apr 15 2002 - 05:49:56 CDT
