Re: Import very slow-URGENT!!!

From: Alex Hudghton <alex_at_alenda.freeserve.co.uk>
Date: Thu, 12 Aug 1999 12:39:55 +0100
Message-ID: <7oubqg$j7i$1@taliesin.netcom.net.uk>

Anurag Minocha wrote in message <37B29EDD.99F887D9_at_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.
>

I assume you are doing this to start with a 'base' copy of the data (?) Why not keep a database copy on the system or on tape and restore from that (i.e. copy the datafiles and recreate the controlfile) each time you want a refresh ?

Alex Received on Thu Aug 12 1999 - 06:39:55 CDT