SQL Script for eliminating table extents.

Hello all,

First, I am assuming that the export/import will create tables with a default size and extent size regardless of how much data will go into that table. YES / NO???

Second,
Does anybody have an SQL script that will:

1. look at all the tables/indexes in a tablespace
2. formulate a drop table and create table/index script
3. look at current space used by the table/index
4. include in the create table/index command initial sizes in order to minimize the number of extents a table/index uses

Thanks,
David Priebe
alphora7_at_renfrew.edu.on.ca Received on Fri Jan 26 1996 - 17:26:37 CST