Re: Replicating DB onto test DB without data and inital extent sizes

Is the solution you are really looking for to get Oracle defaults for the table creation? If you only want to modify storage parameters for a few tables in your database, you can run IMP on your dump file with SHOW = Y and LOG = my_ddl.sql, which will spool the DDL for all the objects in the dump file into my_ddl.sql file. Then you could modify the storage parameters for the tables needed and execute that DDL, followed by IMP with IGNORE = Y.

Hope that helps.

Steve Walterhouse wrote:

> You can pick up a database modeling tool Star Designor (by Powersoft,
> now Sybase) that will connect to your Oracle7 database via ODBC. This
> tool will reverse engineer table definitions into a physical data model,
> but won't bring in initial extent sizes. You can then use this tool to
> generate a create database and create table scripts (no extent info).
> After creating new db, export old db and import into new db. Since
> tables already exist, initial extent info in .dmp file is not
> referenced, but rows are brought in.
>
> The last time I checked, Star Designor sold for about $289.
> To be fair, Oracle now has a similar tool - Database Designor, price
> unknown.

--
Lembit Loo
Senior Consultant

Oracle Corporation

Disclaimer: all opinions expressed here are my own and do not necessarily
represent those of Oracle Corporation.