Re: Export/Import without initial extents

From: Jonathan Gennick <gennick_at_worldnet.att.net>
Date: 1998/03/25
Message-ID: <6f9rg0$otu@bgtnsc02.worldnet.att.net>#1/1

On 23 Mar 1998 01:07:52 GMT, jamesf4ais_at_aol.com (Jamesf4ais) wrote:

>Is there a way to export a database definition without data and without storage
>parameters?

You can do the export without the data by using "ROWS=N" in your export command:

exp73 system/manager_at_db_name owner=xxx rows=n file=c:\nodata.dmp

I just used it today to make an empty copy of a schema for deployment to a client.

I'm less certain about doing it w/o storage parameters. The two databases I used today had different storage areas, but import never complained about those differences when I imported the data. Funny, I never thought about that til just now.

Jonathan Received on Wed Mar 25 1998 - 00:00:00 CST