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

From: Pavel Polcar <pavel.polcar_at_berit.cz>
Date: 1998/05/27
Message-ID: <01bd8963$8ba584d0$47c3657e@polcar_nt4006>#1/1

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

> 

Received on Wed May 27 1998 - 00:00:00 CDT