Re: How to free empty_blocks

As Sybrand said the initial extent is, with all existing versions of Oracle, never dropped unless you drop the object. Empty_blocks are blocks above the High Water Mark, HWM, and as such have never held data since the table was created or last truncated.

If the initial extent size of the table is too large then you need to drop and re-create it.

Before you read Expert-One-On-One you need to read the DBA Administration manual to get the basics down.

HTH -- Mark D Powell -- Received on Thu May 05 2005 - 14:38:20 CDT