Re: how much import is slower than export?

From: David Van Zandt <dvanzandt_at_iquest.net>
Date: Mon, 23 Jul 2001 08:56:26 -0500
Message-ID: <t2W67.670$uD5.408705@news1.iquest.net>

One person's opinion: count on a worse case of perhaps 4:1. Factors include: SORT_AREA_SIZE and TEMP tablespace; direct vs conventional load; file distribution over mount points; and of course, excluding the index build from the initial import (see use of INDEXFILE).

HTH, Dave Van Zandt
OCP "Ed Wong" <ewong_at_mail.com> wrote in message news:a5ae1554.0107222222.28bee668_at_posting.google.com...
> I need to do a full export/import of my prod db into a new instance
> for a project very soon. I want to know how long it's going to take
> to import because import normally takes much longer than export.
> Export(non-direct mode) my 20GB instance takes me 15 hours. Can I
> estimate how long it will take for import? (if exp/imp performance is
> linear?) The two instances are in same machine same instance
> configuration.
Received on Mon Jul 23 2001 - 08:56:26 CDT