Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003
    Location
    Universe.MilkyWay.SolarSystem.Earth.NorthAmerica.Canada.Quebec.Chicoutimi;
    Posts
    9

    Question Unanswered: Reducing tablespace size

    Hi all,

    How do I reduce a tablespace size ? Because freespaces of some of my tablespaces are pretty big (e.g. about 50% of a 2 gig file), so I ask if there is a way to reduce the size of these tablespaces, without deleting important data ?

    In other words, how to flush freespace of a tablespace ?

    Thank you

  2. #2
    Join Date
    Nov 2002
    Location
    Desk, slightly south of keyboard
    Posts
    697
    If the used space isn't fragmented then simply resize the datafiles...

    ALTER DATABASE DATAFILE 'x:\y\z\a.DBF' RESIZE 512M

    If it is fragmented, you won't be able to resize below the point at which blocks are occupied. You can *try* coalescing the space also which may help before the resize....

    ALTER TABLESPACE <tsname> COALESCE

    If you still can't get the size down then you can move the objects into another tablespace, resize the space and then move them back.

    I've read loads about reducing ts size recently, and can only say it does not appear to be an exact science

    Hth
    Bill

Posting Permissions

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