Identify which objects are inside the tablespace

posted Sep 10, 2010, 9:25 AM by Sachchida Ojha
SELECT
      owner
    , segment_name
    , segment_type
  FROM
      dba_segments
  WHERE
      tablespace_name='<tablespace_name>';
Comments