Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> HWM - Import

HWM - Import

From: koz <c.markus_at_comcast.net>
Date: 22 Mar 2007 10:47:03 -0700
Message-ID: <1174585623.450590.15560@p15g2000hsd.googlegroups.com>


I'm reloading all tables in a database (about 200 gig), and have decided to truncate and re-run the import instead of drop.

Is it better to truncate with or without reuse storage parm?

The data we are loading is fairly dynamic, and the number of rows may of increased up to 5% on about 25% of the tables.

Thoughts? Received on Thu Mar 22 2007 - 12:47:03 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US