Re: How to free unused space in a tablespace?

Odd Bjørn Andersen wrote:
> I am new to Oracle so this may seem a silly question, but is there a simple
> way to free unused space in a tablespace. I could export and import the data
> I suppose, but the problem is that there is not much free disk space.
>
> Regards
> Odd B Andersen
>
>

Unused space is already free to use. It can be seen in the DBA_FREE_SPACE dictionary view.

Do you mean to coalesce free space? Which version of Oracle are you using? Are you using Locally Managed Tablespaces or Dictionary Managed?

Cheers,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown