Re: Packing tables/indexes

|> >The only way to free space in a table due to deletion of rows is the TRUNCATE
|> >command, which deletes _all_ the rows in the table and optionally returns all
|> >extents but the initial allocation to the free pool. It's not possible to delete
|> >some of the rows of a table and free up some of the space.
|> >
|> >Paul
|> >
|>
|> Deleting rows from TableA may free up space for inserting new rows into TableA
|> but it will not free up the space for any other tables or indexes to use unless
|> you compress the data via an export, drop or truncate, and import.
|>
|> Loren
|>

However, export will use an allocation equal to the total amount allocated whether or not it is used. Therefore, you must modify the DDL to the size that you want.

-- 
Richard G. Ramirez, Ph. D.
Assistant Professor of MIS
Iowa State University