Export problem - so many synonyms.

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 Sun Apr 14 2002 - 19:49:11 CDT