Simple is Hard

SET LINESIZE 120 SET PAGESIZE 99 COLUMN refs_table FORMAT A40 COLUMN table_referenced FORMAT A40 BREAK ON refs_table SKIP 1 SELECT owner || '.' || name refs_table, referenced_owner || '.' || referenced_name table_referenced FROM all_dependencies WHERE owner LIKE UPPER ('&1') AND TYPE IN ( 'PACKAGE', 'PACKAGE BODY', 'PROCEDURE', 'FUNCTION' ) AND referenced_type IN ('TABLE', 'VIEW') ORDER BY owner..

select b.tablespace_name, c.bytes/1024/1024 as usage, b.table_name, a.comments from dba_tab_comments a, dba_tables b , dba_segments c where a.owner = '유저명' and table_type = 'TABLE' and a.owner = b.owner and a.table_name = b.table_name and a.table_name = c.segment_name and a.owner = c.owner and c.segment_type = 'TABLE' order by 3 위의 쿼리는 테이블스페이스 , 테이블명, 테이블 코멘트 등의 간편한 조회를 위한 쿼리 이다. SYSTEM, SYS유저로 ..