Re: Why is bytes not = initial extent when extents = 1 in seg view
Date: Fri, 03 Feb 1995 22:55:00 -0500
Message-ID: <l.carl.pedersen-0302952255000001_at_kip-1-sn-350.dartmouth.edu>
In article <1995Feb1.203436.15948_at_tron.bwi.wec.com>, Mize.T.E%WEC_at_DIALCOM.TYMNET.COM (Tom Mize) wrote:
>when I view dba_segments, I get the following:
>
>CDAS TCDASQLS TABLE SCDA0010 5 2
>
>bytes extents initial next min ext max ext
>1054720 515 1 1048576 10240 1 121 0 1 1
>
>the view dba_extents verifies that segment tcdasqls has only 1 extent.
>
>How is it that the bytes is > the initail extent when I only have 1
>extent? Please let me know what fundamental principle I have missed.
>Thanks in advance, Tom Mize
my guess is that it is showing you what the initial extent *would* be if the table was truncated and rebuilt. you can change the storage clause after data exists, but it won't change the existing arrangement of data.
i've bcc'd our dba on this so he can tell us if i've lied. Received on Sat Feb 04 1995 - 04:55:00 CET