| Oracle space Question [message #90485] |
Fri, 28 November 2003 10:35  |
Bada
Messages: 1
Registered: November 2003
|
Junior Member |
|
|
|
What is the difference between Tablespace freespace and freespace within an extent?
|
|
|
|
| Re: Oracle space Question [message #90497 is a reply to message #90485] |
Tue, 09 December 2003 03:31  |
David Pember
Messages: 8
Registered: December 2003
|
Junior Member |
|
|
Hi.
Tablespace freespace is the space that can be used by any object being created, or 'extended' in that tablespace.
The extent freespace is the freespace available to a specific object, e.g. Table. An object is comprised of a number of extents (which is a collection of data blocks) - and is the 'reserved' space for the object. Extents will therefore have freespace for new rows to be created in a table, or rows in an index etc.
regards
Dave
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
