Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Import very slow-URGENT!!!
Hi Anurag,
I dont`t know why you do that, but have a look on databases Logs
(ORCLALRT.log ?) are there any `checkpoint not complete`.
If there are, you surely can tune your database.
change SGA Parameters, RedoLogfiles, or create an new instance with better
blocksize
have a look at www.hoffmann-kiel.de/stdinst.html
Christoph
Anurag Minocha schrieb in Nachricht
<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.
>
>Thanks
>anurag
>
>also reply at
>anurag_at_synery-infotech.com
>
Received on Thu Aug 12 1999 - 14:48:14 CDT