Export - Compress question

   I have a table of 400K bytes with an inital extent of 256K and a next of 4K. It has thrown extents.

   I exported the table, truncated the table, reset the storage parameter next to 256K and imported the table. The export parfile had compress=Y.

   After import the table came back in at two extents. I thought compress always forced the existing rows into one extent.

   Did I miss something?

Van

   PS: the only table index which was 350K had an initial extent of 256K and a next of 4K. I reset its storage parameter next to 256K when I did the table. After import the index is in one extent.

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!