Doc Original: dba_seg.sql | Type: DBA | SubType: | Cible: dba_segments | Desc: Liste les objets dans les tablespaces sauf sys et system !! | # column ts_name format a 15 word_wrapped column owner format a 15 word_wrapped column segment format a 15 word_wrapped column type format a 15 word_wrapped SELECT substr(tablespace_name,1,15) ts_name, /*Tablespace name*/ substr(owner,1,15) owner , /*Owner of the segment*/ substr(segment_name,1,15) segment, /*Name of the segment*/ segment_type type /*Type of segment (ex. TABLE, INDEX)*/ -- extents, /*Number of extents in the segment*/ -- blocks, /*Number of db blocks in the segment*/ -- bytes /*Number of bytes in the segment*/ FROM sys.dba_segments where owner <> 'SYS' and owner <> 'SYSTEM';