System tablespace space issue.

  I am facing tables fragmentation problem in my system tablespace and I don’t have enough space available on my hard drive for adding new datafile.  I have identified fragemented tables in system tablespace but unable to release this space. My system tablespace is locally managed and oracle version which I am using is 10g.

 

Query result (with fragmentation) I have used below query for finding fragmentation and the result  are listed below.

 

select table_name,round((blocks*8),2)||'kb' "size"

 from user_tables

 where table_name IN('SOURCE$','IDL_UB1$','IDL_UB2$')

 

TABLE_NAME

WITH FRAGMENATION(KB)