Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003
    Location
    Nottingham, UK
    Posts
    12

    Question Unanswered: Drop table's wasting space

    Hi

    We have noticed that after we dropped a 1.2Mn row table the available space marked as free was unchanged and that there was a chunk of the tablespace maked as "other" which was the same size as the table just dropped.

    If we reorg all the other tables in the tablespace it has no effect on this "other" space, my question is, have we lost this space or can we get it back? Would we have to rebuild the tablespace?

    Thanks
    Jamie

  2. #2
    Join Date
    Sep 2002
    Posts
    456

    Re: Drop table's wasting space

    what kind of tablespace is it? SMS or DMS and can you provide the output?

    dollar

    Originally posted by wallisj
    Hi

    We have noticed that after we dropped a 1.2Mn row table the available space marked as free was unchanged and that there was a chunk of the tablespace maked as "other" which was the same size as the table just dropped.

    If we reorg all the other tables in the tablespace it has no effect on this "other" space, my question is, have we lost this space or can we get it back? Would we have to rebuild the tablespace?

    Thanks
    Jamie

Posting Permissions

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