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 -> Re: Replicating DB onto test DB without data and inital extent sizes

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

From: Steve Walterhouse <microcon_at_magicnet.net>
Date: 1997/10/18
Message-ID: <3448340E.7FC6@magicnet.net>#1/1

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

Original text of this message

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