At first , you need to verify what you say by using
select owner, segment_name, sum(bytes), sum(blocks) from dba_Segments where tablespace_name = 'yourtabelspace' group by owner, segment_name;if there is something , it means your tablespace actually contains objects .I guess what troubles you is tempary tablespace or rollback tablespace , usually they will grow under some algorithm by oracle , there is no permanent objects inside it .
select owner, segment_name, sum(bytes), sum(blocks) from dba_Segments where tablespace_name = 'yourtabelspace' group by owner, segment_name;if there is something , it means your tablespace actually contains objects .I guess what troubles you is tempary tablespace or rollback tablespace , usually they will grow under some algorithm by oracle , there is no permanent objects inside it .
for rollback tablespace , a cycling algorithm is implemented . But I think Oracle Reference has the best answer anyway
改一下就OK了。