set lines 120
set pages 1000
clear col
ttitle off
col segment_name form a30 head “セグメント名”
col segment_type form a10 head “SEG_TYPE”
col tablespace_name form a10 head “表領域名”
SELECT segment_name,segment_type,tablespace_name
FROM user_segments
WHERE tablespace_name=’SYSTEM’
/*
AND segment_type IN (‘TABLE’, ‘INDEX’)
ORDER BY segment_name
*/
ORDER BY segment_type
;
clear col
ttitle off
