Re: Export/Import without initial extents

In article <6f6oom$5ab$1_at_wyrm.its.uow.edu.au>,   Phil Herring <revdoc_at_uow.edu.au> wrote:
>
> In article <1998032301075200.UAA00707_at_ladder03.news.aol.com> Jamesf4ais,
 jamesf4ais_at_aol.com writes:
> >Is there a way to export a database definition without data and without
 storage
> >parameters?
>
> AFAIK, there is no *simple* way. The only solution that I can think of is to
> use the INDEXFILE parameter to extract a list of CREATE TABLE statements,
> editing that, running it, and doing an import of the data. You'll have to
> be careful with the import - if you have foreign keys, you'll have to
> import the tables in the right order to avoid errors.
>
> ---------------------------------------------------------------------------
> Copyright 1998 Phil Herring. This article may not be reproduced for profit.
> ---------------------------------------------------------------------------
>

I may be missing something here, but what about using ERWIN, or some other similar product, to reverser engineer the database. ERWIN gives you a substantial amount of control over what you want to forward engineer, so the storage parameters ?shouldn't? be an issue.

Ben Salemi
Global Consulting Group

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue Mar 24 1998 - 00:00:00 CST