Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Location
    London
    Posts
    2

    Unanswered: Freeing up text space in a table

    Hello all.
    I have a database that has a lot of text space allocated on a table but not used.
    If you do sp_spaceused <table_name>,1 the unused part is 400Mb. I want to reclaim this space, but have not found a valid sybase way of doing it with reorg or dbcc. The only way I have done it so far is to bcp the data out, truncate the table, and bcp it back in again. Not the best really.
    Any bright ideas ???

  2. #2
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    You can just rebuild the clustered index(indid 1).

  3. #3
    Join Date
    Sep 2003
    Location
    London
    Posts
    2
    Tried that, various reorg commands and a dbcc command as well. Have a case open with sybase at mom, but still awaiting reply .......
    bcp is my friend at moment !!!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •