Re: Import very slow-URGENT!!!

From: <kal121_at_my-deja.com>
Date: Thu, 12 Aug 1999 20:55:33 GMT
Message-ID: <7ovcc0$n3h$1@nnrp1.deja.com>

You can increase the size of your buffer parameter, which may help some. I've also found that using a large rollback segment can speed things up.

In article <37B29EDD.99F887D9_at_synergy-infotech.com>, Anurag Minocha <anurag_at_synergy-infotech.com> wrote:
> Hi,
> We are using oracle 8.0.5 in NT. Our's is a developement database
hence
> we have to drop all the objects for a particular user and import them
> again. This we do atleast twice a day.
> The command we use to expoirt is as follows
> exp80 <username>/<password>@<service name> file= exp.dmp full=y
>
> and to import we use
> imp80 <username>/<password>@<service name> file=exp.dmp fromuser=r2
> touser=r2
>
> The problem is that the import has become very slow and sometimes it
> justs hangs after importing all the tables and before enabling the
> constraints.
>
> Any help on how to speed up the import process will be appreciated.
>
> Thanks
> anurag
>
> also reply at
> anurag_at_synery-infotech.com
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Aug 12 1999 - 15:55:33 CDT