Re: export with compress=Y

Dick Allie (allie_at_ionet.net) wrote:
: The two extents are merged to create one extent that is the total size of
: the two extents. It uses the size in bytes from dba_segments to create
: the initial extent. All other features remain the same such as pctfree,
: pctused and next. Be sure to get the constraints, grants and indexes if
: you drop the table to reimport it because these objects are dropped with
: the table.
:

My experience has shown that oracle will not create the new table with an extent size that is less than the original extent.

For example,

table A has 2 extents of 100 blocks each for a total allocation of 200 blocks. But, in actuality, it is only currently using 50 blocks.

I export this table with compress=y and then drop the table.

When it is imported, the first extent will not be 50 blocks, but 100 blocks.

Tony Damon Received on Fri Feb 16 1996 - 00:00:00 CET