Re: Weird extent sizes in locally managed tablespace

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 3 Aug 2005 17:18:27 -0700
Message-ID: <1123114707.183127.238180@g49g2000cwa.googlegroups.com>

Since you said "created" I will ignore what happens in dictionary tablespaces that are converted to auto-allocate in place.

Are there now or were there other tables/indexes allocated in this tablespace? If so then the odd extents could be extents freed by these objects due to their being dropped, moved, or rebuilt and Oracle re-allocated the existing extent to your table when it needed an extent. The auto-allocate logic seems to like to fill in from the front of the file working its way toward the end of the file.

HTH -- Mark D Powell -- Received on Wed Aug 03 2005 - 19:18:27 CDT