Home » Developer & Programmer » Designer » Oracle space Question
Oracle space Question [message #90485] Fri, 28 November 2003 10:35 Go to next message
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 Go to previous message
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
Previous Topic: oracle 8i enterprise edition for W2k professional
Next Topic: Tuning Question
Goto Forum:
  


Current Time: Tue Mar 19 05:25:40 CDT 2024