4 Replies Latest reply: Nov 16, 2012 5:43 PM by spur230 RSS

    partition drop  not increasing free space in dba_free_spaces

      I am Using Oracle

      I had a script that droped partitions for a table which should have dropped nearly 30 gb of data. We have data and index tablespace.

      Query of dba_free_space showed no change on data tablespace. However, index tablespace showed increase in free space.
      select  sum(bytes / (1024 * 1024 * 1024)) "Size (GB)"  from dba_free_space where tablespace_name ='&tbs_name'
      I am using following command to drop partition
      ALTER TABLE table_name
      DROP PARTITION "partition_name" 
      What should be done to increase free space shown for tablespace after partition drop ?

      Thanks for the time.