Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: IMP-00044 - which parameter to increase allocation for database buffers?

Re: IMP-00044 - which parameter to increase allocation for database buffers?

From: INOUE Katsumi <kinoue_at_jp.oracle.com>
Date: 1998/03/12
Message-ID: <6e7phs$1kn$1@inet16.us.oracle.com>#1/1

In article <3505D718.1F7C_at_ums1.lan.mcgill.ca>, Brian McCullogh <brian_at_ums1.lan.mcgill.ca> wrote:
>I am encountering an "IMP-00044 - unable to allocate enough memory for
>statement" error during the execution of an Import command. The "Server
>Messages" manual advises "Increase the allocation for database buffers,
>restart the instance, and reexecute the Import command.". Am I correct
>in assuming that I need to change a parameter in my init.ora file, and
>if so, which one would it be? (Oracle 7.3.2.2 on NT 4.)

That should probably be a doc bug. You don't have to bounce the db. All you have to do is specify 'buffer=' parameter for imp73.exe.

Regards,
INOUE Katsumi

-- 
This posting represents the personal opinions of the author. It is not the
official opinion or policy of the author's employer.
Received on Thu Mar 12 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US