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

INOUE Katsumi wrote:
>
> 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.
>

Thanks, that was it. It took a few practice runs to verify, but as I increased the value for each import attempt, the number of errors was reduced and finally eliminated. The fund-raising office here at McGill purchased a package called "Advance" from BSR - Business Systems Resources, Inc. (any other customers out there?). A few of the stored procedures are fairly large - I eventually set the buffer value at 256K.

Brian McCullogh
Information Systems Resources
McGill University
brian_at_ums1.lan.mcgill.ca Received on Fri Mar 13 1998 - 00:00:00 CST