--DBA_SEGMENTS
(所有数据库分段[例如表、索引、分区、LOB 等]的存储空间)
查表占用空间
SELECT SEGMENT_NAME,SUM(BYTES)/1024/1024/1024 GB FROM DBA_SEGMENTS WHERE SEGMENT_NAME='表名' GROUP BY SEGMENT_NAME
--DBA_TAB_COLUMNS
查表结构/列信息/字段信息
SELECT TABLE_NAME,COLUMN_NAME,DATA_TYPE,DATA_LENGTH,DATA_PRECISION,DATA_SCALE,NALLABLE,COLUMN_ID FROM DBA_TAB_COLUMNS WHERE TABLE_NAME IN ('表名') ORDER BY TABLE NAME,COLUMN_ID