Re: Export/Import without initial extents

From: Phil Herring <revdoc_at_uow.edu.au>
Date: 1998/03/23
Message-ID: <6f6oom$5ab$1@wyrm.its.uow.edu.au>#1/1

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.

---

Received on Mon Mar 23 1998 - 00:00:00 CST