Re: IMP-00044 - not enought memory

Error message is a bit vague.
Could be either one of three, which I will mention all\ 1 the buffer parameter on the imp command line 2 db_block_buffers in init<sid>.ora
3 (more likely) shared_pool_size in init<sid>.ora

Hth,

Sybrand Bakker, Oracle DBA

"Marcel Schöbi" <mschoebi_at_gmx.ch> wrote in message news:9463vk$9hk$1_at_news1.sunrise.ch...
> Hello,
>
> I have a large package.SQL 108KB or wrapped Package.plb 218Kb on my NT4.0
> 128MB RAM with Oracle 8.0.4.2.0.
> When I import (imp80)a dump-file including the wrapped Package I get the
> error IMP-00044 - not enought memory !! This happens not with a dump file
> including the SQL-version of the package!
>
> The documentations says:
> IMP-00044: unable to allocate enough memory for statement
> Cause: Import was unable to allocate sufficient memory to read in the
> specified statement and execute it.
>
> Action: Increase the allocation for database buffers, restart the
 instance,
> and re-execute the Import command.
>
>
> But what buffers I have to increase?
>
> E-Mail: MSchoebi_at_gmx.ch
>
>
Received on Thu Jan 18 2001 - 08:39:50 CET