时间:2020-02-27来源:电脑系统城作者:电脑系统城
SET PAGESIZE 60;
COL SEGMENT_TYPE FOR A12;
COL FILE_NAME FOR A64;
COL SEGMENT_NAME FOR A24;
COL TABLESPACE_NAME FOR A24;
COL SEGMENT_OWNER FOR A12;
SELECT E.OWNER AS SEGMENT_OWNER,
E.SEGMENT_TYPE AS SEGMENT_TYPE,
E.SEGMENT_NAME AS SEGMENT_NAME,
E.PARTITION_NAME AS PARTITION_NAME,
E.TABLESPACE_NAME AS TABLESPACE_NAME,
F.FILE_NAME AS FILE_NAME,
SUM(E.BYTES) / 1024 / 1024 AS SEGMENT_SIZE
INNER JOIN DBA_DATA_FILES F ON E.FILE_ID= F.FILE_ID
WHERE E.OWNER='&OWNER'
AND E.SEGMENT_NAME='&SEGMENT_NAME'
GROUP BY E.OWNER
,E.SEGMENT_TYPE
,E.PARTITION_NAME
,E.SEGMENT_NAME
,E.TABLESPACE_NAME
,F.FILE_NAME
ORDER BY SEGMENT_SIZE DESC;
2023-03-17
使用PLSQL远程连接Oracle数据库的方法(内网穿透)2023-03-15
Oracle数据库完整卸载的完整步骤2023-03-09
图文讲解完全卸载SQL server2019的完整步骤天工作的时候,用到了oracle数据库建表,发现navicat中对于oracle的支持没有那个主键自增的按钮,下面这篇文章主要给大家介绍了关于Navicat设置Oracle数据库主键自增的方法步骤,需要的朋友可以参考下...
2023-03-06