- 1) An extent is a set of contiguous blocks allocated in a database. In the Oracle database program, the first set of contiguous blocks, set up automatically when a segment is created, is called the initial extent. After the initial extent has been filled, the program allocates more extents automatically. These are known as next extents. 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.
2) 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.
| LAST UPDATED: |
05 Jul 2003
|

 |
Do you have something to add to this definition? Let us know.
Send your comments to techterms@whatis.com
|

');
// -->
 |
 |
|  |
RELATED CONTENT
 |
How to create a database link in Oracle
Part of our "How do I do that in Oracle?" series, this tip explains in detail how to create a database link as well as how to troubleshoot db link...
|
 |
Most clicked stories of 2007
Our top five most popular learning guides, news stories, tips, blog posts, and expert responses of 2007.
|
 |
How do I do that in Oracle?
This series is a collection of tips that explain in detail how to perform specific tasks in Oracle related to database administration.
|
|

|