how to free and used space in a table

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

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.

so you arent an oracle dba then

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