Re: Import problem - not enough memory

From: Leigh Carpenter <leighc_at_mincom.com>
Date: 1997/12/23
Message-ID: <01bd0ff3$76508560$644111ac@herne.mincom.oz.au>#1/1

Steve,

DB_BLOCK_BUFFERS are the no. database buffers cached in the SGA and is what the message is referring to.
Leigh

Steve Sochacki <steve.sochacki_at_exmi01.exch.eds.com> wrote in article <01bd0fa4$9f375a20$b42fe4c7_at_SAMHC180.sys.eds.com>...
> I'm performing a full database import and everything goes well except the
> stored procedures. I get messages ORA-4043, IMP-00003, IMP-00017 and
> IMP-0044. IMP-0044 states 'Unable to allocate enough memory for
statement'
> and the action is 'Increase the allocation for database buffers, restart
> the instance, and re-execute the import command'. I'm sure the message
> refers to an INITxxx.ORA parameter, but there isn't any 'database buffer'
> parameter. Can anyone help? I'm going to increase the DB_BLOCK_BUFFERS
> parameter while waiting for an answer and see if that helps.
>
>
Received on Tue Dec 23 1997 - 00:00:00 CST