SELECT
A.OWNER AS “模式”,
A.SEGMENT_NAME AS “表名”,
A.BYTES/1024 AS “大小(KB)”,
A.TABLESPACE_NAME AS “所属表空间”,
B.COMMENTS AS “表注释”
FROM DBA_SEGMENTS A,DBA_TAB_COMMENTS B
WHERE A.OWNER=B.OWNER
AND A.SEGMENT_NAME = B.TABLE_NAME
–AND A.OWNER=‘SYSDBA’
ORDER BY SEGMENT_NAME ASC;