Get back the allocated space for the table.

From: M.Balaji <muni_balaji_at_yahoo.com>
Date: 22 Aug 2002 20:51:31 -0700
Message-ID: <3ce48062.0208221951.7efbf67b@posting.google.com>

Hi,
We are working on a Datawarehousing Application. Where the database is partitioined based on the branch code. We have a seperated tablespace for each branch and when the rows inserted into the table, the data goes and sits in the corresponding partition based on the branch.
Now the problem is after i delete the rows belonging to the particular branch, the space taken for the data is still allocated and it is not freed.How do i get the disk space back.

Table Name           :ME_CUST_AC_MASTER    
Object Type          :TABLE PARTITION      
Tablespace Name      :ME_DTT799        
Size Occupied        :5.72     
Initial Extent       :131072     
Next Extent          :131072         
Extents Allocated    :42    
Total Size of the Ext:6000640 
Max Extents          :2147483645

1 select br_code, version_date ,count(*) 2 from me_cust_ac_master
3* group by br_code,version_date

BR_C VERSION_ COUNT(*)
---- -------- ----------
0777 20020630 24896 - This is the data for another branch and tablespace is dtts777

Pls help me to solve this problem
Thanks and Regards
M.Balaji Received on Thu Aug 22 2002 - 22:51:31 CDT