Importing tables w/large initial extents into a small database

From: Jonathan Gennick <gennick_at_worldnet.att.net>
Date: Wed, 06 May 1998 23:56:40 GMT
Message-ID: <6iqtbi$36t@bgtnsc03.worldnet.att.net>

Today I needed to setup an empty copy of a database in order to do some testing. I took an export of the database using the following command:

exp73 owner=XXX file=ffff log=llll ROWS=N

Even though no data was exported, all the CREATE TABLE statements in the export file contained storage clauses with very large initial extents. So in order to load this export file into another database, I had to allocate a very large tablespace to hold a bunch of empty tables. Is there a way to do the import in such a way that the tables are recreated using the default storage parameters defined in the target database? Received on Wed May 06 1998 - 18:56:40 CDT