DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: alter tablspace ts_name delete unused;

  1. #1
    Join Date
    Jun 2001
    Posts
    243
    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...

  2. #2
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    I hope u think about command:

    ALTER TABLE table_name DELETE UNUSED;

  3. #3
    Join Date
    Sep 2001
    Location
    Fort Smith
    Posts
    184
    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

  4. #4
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938

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


  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    alter table xxxx deallocate unused

    deallocate freespace above segment's HWM

  6. #6
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    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.

  7. #7
    Join Date
    Dec 2001
    Location
    USA
    Posts
    620
    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
  •  


Click Here to Expand Forum to Full Width