F.TOTAL_BYTES "空闲空间(M)",
F.MAX_BYTES "最大块(M)" FROM (SELECT TABLESPACE_NAME,
ROUND(SUM(BYTES) / (1024 * 1024), 2) TOTAL_BYTES, ROUND(MAX(BYTES) /
(1024 * 1024), 2) MAX_BYTES FROM SYS.DBA_FREE_SPACE GROUP BY
TABLESPACE_NAME) F, (SELECT DD.TABLESPACE_NAME,
ROUND(SUM(DD.BYTES) /
(10http://www.mianfeiwendang.com/doc/dba9a779825b68483416ac9624 *
1024), 2) TOT_GROOTTE_MB FROM SYS.DBA_DATA_FILES DD GROUP BY
DD.TABLESPACE_NAME) D WHERE D.TABLESPACE_NAME =
F.TABLESPACE_NAME ORDER BY 4 DESC;
收缩表空间
ALTER TABLESPCE TS_AJ_DATA COALESCE;
增加表空间大小
SELECT T.TABLESPACE_NAME, T.FILE_NAME, T.BYTES / 1024 / 1024 / 1024
FROM DBA_DATA_FILES T
WHERE T.TABLESPACE_NAME = 'TS_AJ_DATA';
ALTER TABLESPACE TS_AJ_DATA ADD DATAFILE '/DATA/TS_AJ_DATA05_10G.DBF'
SIZE 10000M
AUTOEXTEND OFF;
检查不起作用的约束