oracle數據庫如何查看表的表分區的信息每個表分區的名字和所屬表空間?
SELECT segment_name, SUM(bytes) / 1024 / 1024 Mbytes FROM dba_segments WHERE segment_type = 'TABLE PARTITION' AND Tablespace_name = 'SYSTEM' GROUP BY segment_name;
上一篇運行sql文件出錯怎么辦
下一篇奔馳大g卡鉗改裝要編程嗎
oracle數據庫如何查看表的表分區的信息每個表分區的名字和所屬表空間?
SELECT segment_name, SUM(bytes) / 1024 / 1024 Mbytes FROM dba_segments WHERE segment_type = 'TABLE PARTITION' AND Tablespace_name = 'SYSTEM' GROUP BY segment_name;