how to free and used space in a table

[younusdba]

Hi all,


i am oracle dba, so can anyone tell me that any command or query to know the free and used space in a paticular table.quick response will higly appreciate.



Regards

[PAVB]

do you mean unused space? - like making unused space available at tablespace level?

In the affirmative case research alter table deallocate and alter table move.

[davey23uk]

so you arent an oracle dba then

[gandolf989]

Look at the dbms_space package in your database, and read the concepts manual!