Dear all,

How do I reclaim unused space?

Scenario,
Initially I have a tablespace with 24 datafile each already extended up to 32767M.

through the export and import dump operation I was able to reduce from 24 datafiles to 16 datafiles.

but still not enough as my customer want it to be smaller....

Code: [Select all] [Show/ hide]

SELECT owner, tablespace_name, count(0), sum(bytes)/1024/1024 FROM dba_segments GROUP BY cube(owner,tablespace_name)
  2  ORDER BY owner, tablespace_name;

BIGDATA              BIGDATA                     293          498,742.750
BIGDATA                                        293          498,742.750

after next round of deletion of rows from the tables, there actually an increase in segments size


after the deletion of rows from the tables, there should be any decrease in segment size right since segment size will only decrease after truncate or drop operation?

I can only know the actual segment size used after reimporting the schema again right?

thanks a lot of your help

Dear all,



but still not enough as my customer want it to be smaller....

but still not enough as my customer want it to be smaller....

The reason is that developers will be writing code against a smaller subset of data, which will give them faster results than in the production database.