Re: Help Export /Import -- Prob

From: Chrysalis <cellis_at_iol.ie>
Date: 1997/04/27
Message-ID: <33632BF0.3069@iol.ie>#1/1

Brian Spears wrote:
>
> HI,
> Keep in mind we have no space to place with...
>
> I have exported 4 tables with the compress=y. The tablespace was
> snip

Unfortunately, compress=y doesn't.

What it does is consolidate all your rows into the smallest number of extents in the same-sized table (where they may have previously been spread out due to deletions, etc.) It does *not* reduce the size or number of the extents allocated to the table.

The only way you can do this is to export the table, truncate the table and alter the storage allocation of the table (or drop the table the table and re-build it) and then re-import.

Hope this helps.

Chrysalis. Received on Sun Apr 27 1997 - 00:00:00 CDT