Import very slow-URGENT!!!

From: Anurag Minocha <anurag_at_synergy-infotech.com>
Date: Thu, 12 Aug 1999 15:45:57 +0530
Message-ID: <37B29EDD.99F887D9@synergy-infotech.com>

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 Received on Thu Aug 12 1999 - 05:15:57 CDT