Reclaiming space after DELETE of rows with TEXT columns

• Express12

  SSCoach

  Points: 18514

  More actions

  December 19, 2005 at 6:41 am

  #152673

  We have a table w/ a column defined as TEXT.  We delete thousands of rows from this table each day.

  Is the SPACE reclaimed upon DELETE --or-- only upon a SHRINK --or-- does the table have to be physically DROPped and reCREATEd to reclaim the space?

  thx in advance

  BT

• ARUL-285958

  Ten Centuries

  Points: 1081

  More actions

  December 20, 2005 at 9:04 am

  #610616

  Hi there,

  u can shrink the db/table to get avail your space.

  -A

  ---

  Get busy living ....or get busy dying....