Re: Space allocation

truncate table <table name>;

> Hi guys,
>
>
>
> I've a table that at one point had lots of inserts and now the table has
> 3.6Gb worth of space allocated. When I do a select count(*) it returns 0
> rows.
>
>
>
>
>
> How do I release all this space allocated?
>
>
>
> Thanks
>
>
>

===
John Clarke
Sr. Oracle DBA
Centroid Systems, Inc.
(248) 330-3301

--
http://www.freelists.org/webpage/oracle-l