Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re-create 7.3 DB, new blksize, init/next/pct; import; OOPS imports old
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
![]() |
![]() |