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

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. Received on Sat Oct 18 1997 - 00:00:00 CDT