JAVA J2EE 4 U

 SELECT 

    t.owner,

    t.table_name,

    s.tablespace_name,

    ROUND(s.bytes / 1024 / 1024, 2) AS size_mb,

    t.num_rows,

    t.last_analyzed,

    o.last_ddl_time AS last_modified

FROM dba_tables t

JOIN dba_segments s 

    ON t.owner = s.owner 

   AND t.table_name = s.segment_name 

   AND s.segment_type = 'TABLE'

JOIN dba_objects o

    ON t.owner = o.owner 

   AND t.table_name = o.object_name 

   AND o.object_type = 'TABLE'

WHERE t.owner = 'YOUR_SCHEMA'

  AND REGEXP_LIKE(t.table_name, 

       '(_BAK$|_TMP$|_COPY$|_OLD$|_TEST$|_ARCH$|_STAGE$|_SNAP$|_DUP$|^TMP_|^STG_|^BK_|^OLD_|^NEW_|^TEST_)', 

       'i')

ORDER BY size_mb DESC;