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

Home -> Community -> Mailing Lists -> Oracle-L -> Re-create 7.3 DB, new blksize, init/next/pct; import; OOPS imports old

Re-create 7.3 DB, new blksize, init/next/pct; import; OOPS imports old

From: Bob Bryla <rjbryla_at_mhtc.net>
Date: Wed, 26 Apr 2000 17:44:39 -0500
Message-Id: <10479.104236@fatcity.com>


Hello,

Re-created a DB last weekend (7.3.4 under NT) larger blocksize, better segment defaults when creating the
tablespaces, per Oracle tool author's (third party OO layer) recommendations.

Took previous night's export, imported, OOPS, the old init/next/pctincrease/pctfree/pctused were imported along with the tables, this is BAD (and
they have found out the hard way).

I see a few options at a high level, which one(s) make sense: (a) export again; drop all indexes/tables/constraints (about 224 tables total), import twice (?) once with the DDL only
to create the tables and indexes,
import again with the tables already there... (b) create new tables with same names + _NEW, CREATE TABLE ... SELECT AS which should default the new tables' params to the tablespace defaults, then rename orig to _OLD, rename good ones, drop _OLD ones or (c) ???

One of the (few) good things about the tool they're using is that once the tables are there, the tool will automatically generate and run the DDL to create the constraints and indexes.

And any scripts that are out there to automate something like this would be appreciated... Received on Wed Apr 26 2000 - 17:44:39 CDT

Original text of this message

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