What is initial extent? - Definition from Whatis.com

The initial extent is a set of contiguous blocks in a database segment that is automatically allocated when the segment is created. Any set of contiguous blocks allocated after the initial extent is called a next extent. The total number of extents that can be allocated in a database is limited by the amount of storage space available, or in some cases, by the program used.

The term extent is sometimes used in reference to any contiguous space (for example, a set of sectors) on a hard drive that is reserved for a particular file, folder, or application.

This was last updated in September 2005
Editorial Director: Margaret Rouse

Email Alerts

Register now to receive SearchSQLServer.com-related news, tips and more, delivered to your inbox.
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Dig Deeper

Do you have something to add to this definition? Let us know.

Send your comments to techterms@whatis.com