Re: looking for a faster imp

Try using direct path export/import (direct=y). I've seen substantial performance gains on imports using this technique. Also, drop all indexes before the imort and recreate them using the indexfile feature.

C Chang wrote:

> I recently began to use the standard exp nd imp to back-up and reload
> our small 8i DB. I found that with the imp, the process took at least 2
> hours to finish my 350MB DB. Comparing others,it is quite small one,
> but it takes too long to restore. I wonder what is the best and faster
> way to restore the db.dmp file, so the process can fulfill future need.
> Thanks
>
> C Chang
Received on Tue Feb 19 2002 - 00:51:31 CST