Re: Designer 2000 Problem

In article <388d49a6.59257297_at_news.uskonet.com>, Anton <antonvb_at_jungle.com> writes
>Hi
>
>If anyone can shed some light on a problem that I'm having with
>designer 2000 I would appreciate it. I'm trying to reverse engineer a
>database into a server model diagram, however every time I try to
>commit the changes to the repository I get the following error
>
>RME-00224: Failed to close activity
>RME-00222: Failed to dispatch operation to Repository
>RME-00011: Operation 'close' on ACTIVITY has failed
>RME-00020: Internal API error - ORA-04031: unable to allocate 53772
>bytes of shared memory ("unknown object","cursor work he","sort merge
>buffer")
>

From the Oracle 7.3 documentation...

ORA-04031 unable to allocate num bytes of shared memory num, num, num

Cause: More shared memory is needed than was allocated in the operating system process. SGA private memory has been exhausted

Action: Either use the DBMS_SHARED_POOL package to pin large packages, reduce your use of shared memory, or increase the amount of available shared memory by increasing the value set for the SHARED_POOL_SIZE initialization parameter.

Andy
--
Andy Hardy. PGP key available on request