-
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
sonofsita
http://www.ordba.net
-
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.
Once you have eliminated all of the impossible,
whatever remains however improbable,
must be true.
-
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,
Sam
------------------------
To handle yourself, use your head. To handle others, use your heart
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|