出力結果の説明：
OWNER : オブジェクトの所有者
OBJECT_NAME : オブジェクト名
OBJECT_TYPE : オブジェクトのタイプ
STATUS : 状態
set lines 120
set pages 1000
clear col
ttitle off
col OWNER form a20 head “所有者”
col OBJECT_NAME form a30 head “オブジェクト名”
col OBJECT_TYPE form a14 head “タイプ”
col STATUS form a10 head “状態”
SELECT
OWNER
, OBJECT_NAME
, OBJECT_TYPE
, STATUS
FROM
DBA_OBJECTS
/* ■USER_OBJECTSを使用する場合は、OWNER列がない */
WHERE
— OWNER NOT IN (‘SYS’,’SYSTEM’)
OWNER = ‘LETSS’
AND OBJECT_TYPE = ‘TABLE’
— OR OBJECT_TYPE = ‘INDEX’
ORDER BY OWNER
, OBJECT_NAME
/
clear col
ttitle off
