Re: Next Extents

From: Dave Jordan <jordan_at_pt5026.pto.ford.com>
Date: 9 Dec 1994 14:15:44 GMT
Message-ID: <3c9oqg$ie_at_eccdb1.pms.ford.com>


Scott Johnson wrote:

>I just exported a table with 2 million rows and had the extent
>compressed. When I imported the table, the data was in 3 extents.
>I thought that all the data would be placed in one extent. Is there
>a limit to the size of an extent?

Check to see that you don't have a MINEXTENTS value of 3. That would account for the extra extents even if they were left empty after the compression.

David Jordan Received on Fri Dec 09 1994 - 15:15:44 CET

Original text of this message