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

You can speed up exp by setting the direct path parameter (direct = yes) of the export tool. In addition you can use greater buffers or arrays for imp.

Andreas Prusch

In article <01bd8963$8ba584d0$47c3657e_at_polcar_nt4006>,   "Pavel Polcar" <pavel.polcar_at_berit.cz> wrote:
>
> Hi,
> if the purpose is a reorganization, then you can do it table by table (at
> least for larger tables).
> The procedure should be as follows:
> 1. Export the table (preferrably with COMPRESS=y)
> 2. Drop the table
> 3. Optionally: Create the table with (possibly) new storage parameters, but
> DO NOT create any index on the table.
> 4. Import the table (with IGNORE=y if the table was pre-created)
> 5. Create indexes for the table.
>
> Hth,
> --
> Pavel Polcar
>
> mainini_at_hotmail.com wrote in article <6kglle$igr$1_at_nnrp1.dejanews.com>...
> > 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 Thu May 28 1998 - 00:00:00 CEST