Combine DBA_SEGMENTS and DBA_FREE_SPACE : DBA_FREE_SPACE « System Tables Data Dictionary « Oracle PL/SQL Tutorial






SQL> select Owner, Segment_Name, Segment_Type
  2    from DBA_SEGMENTS
  3   where Next_Extent >
  4  (select SUM(Bytes) from DBA_FREE_SPACE
  5    where Tablespace_Name = DBA_SEGMENTS.Tablespace_Name);
SQL>
SQL>
SQL>
SQL>








30.32.DBA_FREE_SPACE
30.32.1.Combine DBA_SEGMENTS and DBA_FREE_SPACE