Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: IMP-00044 - which parameter to increase allocation for database buffers?
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