alter tablspace ts_name delete unused;

Can somebody tell me when I'm supposed to use this command and what does it do?

ALTER TABLESPACE ts_name DELETE UNUSED;

thanks much...

I hope u think about command:

ALTER TABLE table_name DELETE UNUSED;

we have command to release the unused space from the tables and resizing of the tablespaces. there is no delete unused space command either in alter tablespace or alter table commands

What are you trying to delete from the table/tablespace :-)

alter table xxxx deallocate unused

deallocate freespace above segment's HWM

Where did you get 'delete unused' from ??
Did you try and research the statement.

Pando is correct in his syntax.
The command is used if an extent has been given to a segment which is larger than needed.

Quote:

---

Originally posted by Sureshy
Where did you get 'delete unused' from ??
Did you try and research the statement.

Pando is correct in his syntax.
The command is used if an extent has been given to a segment which is larger than needed.

---

Hi,

When should we use this command? What are the advantages?

Thanks,