Re: Export/Import problems

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Sun, 9 Jan 2000 22:59:16 +0100
Message-ID: <947455249.23619.0.pluto.d4ee154e@news.demon.nl>

Try to increase the buffer of the imp command, either during the dialog or by adding buffer=8192000

Hth,

--
Sybrand Bakker, Oracle DBA
<qlos_at_my-deja.com> wrote in message news:859v3e$6t8$1_at_nnrp1.deja.com...
> Hi,
>
> I experience strange problems with Import (Oracle 8) utility. Export
> works fine (at least it terminates succesfully without any warnings),
> but Import doesn't create all objects. Usually missing objects are
> indexes and package bodies. Only errors reported in log are:
>
> IMP-00044: unable to allocate enough memory for statement
>
> Following error explanation I increased database buffers (even ten
> times, db_block_buffers=5000), but it did not help. Should I try with
> higher value or maybe problem in in different place ??
>
> many thanks,
>
> Qlos
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sun Jan 09 2000 - 15:59:16 CST