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
Printable View
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!