SELECT
      owner
    , segment_name
    , segment_type
  FROM
      dba_segments
  WHERE
      tablespace_name='<tablespace_name>';