Re: max extent

From: DBAOracle <dbaoracle_at_aol.com>
Date: 14 Jul 1999 22:35:14 GMT
Message-ID: <19990714183514.29466.00000294@ng-cn1.aol.com>

This depends on the version of Oracle you are on. If it is > 7.2, then you can use unlimited for max extents and you don't have a problem in terms of runing out of extents (though this can cause other problems).

Prior to this, the maximum number of extents an object could have was determined by the block size. I don't remember the numbers anymore, frankly, but I think 249 was the max for a 4k block size...?

Robert Received on Wed Jul 14 1999 - 17:35:14 CDT