반응형

P.677 참조 내용
- DBLS(데이터베이스 ls 또는 Windows 사용자의 데이터베이스 dir)은 THOMAS KYTE의 핵심 스크립트 중의 하나라고 한다.

select object_type, object_name,
decode(status,'INVALID', '*', '') status,
decode(object_type,'TABLE', (select tablespace_name from user_tables where table_name = object_name),
'TABLE PARTITION', (select tablespace_name from user_tab_partitions where partition_name = subobject_name),
'INDEX', (select tablespace_name from user_indexes where index_name = object_name),
'INDEX PARTITION', (select tablespace_name from user_ind_partitions where partition_name = subobject_name),
'LOB', (select tablespace_name
from user_segments
where segment_name = object_name), null)
tablespace_name from user_objects;

반응형