Re: help with space in tablespaces

blah_at_blah.com (blah) wrote in message news:<9luttp$t2r2_at_inetbws1.citec.com.au>...
> Hi All,
>
> When a data tablespace is nealy full and then say 1million rows are deleted my
> query will not show the reduction in data it only shows the space left above
> the high water mark.
>
> Is their a way to show how much space is actually available in the tablespace
> now that 1 million rows have been deleted?
>
> Thanks,
> Chris

Deleting rows from a table has no effect on the space available to the tablespace because once an extent is allocated to an object it belongs to that object and can not be used by any other object. What the delete did do is potentially make space within existing data blocks in the table available for reuse. I say potentially because the ability of Oracle to insert data into existing used blocks depends on the settings of the pctfree and more importantly pctused parameters.

You can find information on block management in the Concepts manual.

You may wish to see the common FAQ articles visit http://www.jlcomp.demon.co.uk/faq/ then choose DBA then look for

How can I reclaim unusable fragments of space in a tablespace ?

• Mark D Powell --