Re: How to speed up the import fase of a DB?

From: <cmohan_at_iname.com>
Date: 1998/05/29
Message-ID: <6kmj70$4kl$1@nnrp1.dejanews.com>#1/1

You can look into a few things.

1. See if you can use the DIRECT PATH option as opposed to conventional path
2. Pre create the table before importing (use IGNORE=Y for importing data)
3. You may want to import the tables only, without the indexes and later

create the indexes.

HTH,
CM
In article <6kglle$igr$1_at_nnrp1.dejanews.com>,   mainini_at_hotmail.com wrote:
>
> Hi,
>
> I need to make an export/import of a very large database (for
> reorganization purposes). I've tryed already the procedure (via
> exp/imp tools) a couple of times, but the import fase is taking too
> much time and I can't effort too much downtime.
> Does anyone know how to speed up the import fase?
> Thank you very much...
>
> Marco.
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Fri May 29 1998 - 00:00:00 CDT