Import/Export peformance?

From: Robert Jungerius <rjungerius_at_death-to-spam.cetecint.com>
Date: 27 Oct 1998 08:27:23 GMT
Message-ID: <01be0183$612c7680$270164bf@wks139>

I've been experimenting with the various imp/exp parameters and found out that importing without constraints and indexes is slower than importing with indexes and constraints. Can somebody clarify these mysterious results???

I want to export/import large databases (10Gb) and I find that import takes too long, are there
settings to improve imp/exp performance? (i'm running Oracle 7.3.3 on NT4).

Thanks in advance,

---

Robert Jungerius
DBA/Software Engineer @ CETEC BV
e-mail: rjungerius_at_yahoo.com
ICQ: 16241759 Received on Tue Oct 27 1998 - 02:27:23 CST