I can still see used space in the tablespace though there are no objects in that tablespace.

Hi,

I have moved the objects out from tablespace FLX_NDX2 and then planning to drop the tablespace.  But I noticed that there is still used space in the tablespace and wondering what is occupying that space. 

Would someone help me out?

Thanks

Suresh

select segment_name,owner,segment_type from dba_segments where tablespace_name like 'FLX_NDX2';

no rows selected

April 26, 2012                       Database Used / Free Space                           Page:    1
                                      
                                                                              No of      Max Free
Tablespace Name           Size (MB)      Used (MB)      Free (MB)  % Used Free Exts      Ext (MB)
-------------------- -------------- -------------- -------------- ------- --------- -------------
FLX_NDX2                     100.00          20.00          80.00   20.00         1         80.00
                     -------------- -------------- --------------
sum                          100.00          20.00          80.00