ORA-01653: 表 XXXXX 无法通过 1024 (在表空间SYSTEM中)扩展

查看表空间使用情况

SELECT
	UPPER( F.TABLESPACE_NAME ) "表空间名",
	D.TOT_GROOTTE_MB "表空间大小(M)",
	D.TOT_GROOTTE_MB - F.TOTAL_BYTES "已使用空间(M)",
	TO_CHAR( ROUND( ( D.TOT_GROOTTE_MB - F.TOTAL_BYTES ) / D.TOT_GROOTTE_MB * 100, 2 ), '990.99' ) "使用比",
	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 ) / ( 1024 * 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;

查看表空间是否自增及最大空间

SELECT
	T.TABLESPACE_NAME "表空间",
	D.FILE_NAME "数据文件",
	D.AUTOEXTENSIBLE "是否自增",
	D.BYTES "当前大小",
	D.MAXBYTES "最大值",
	D.STATUS "状态"
FROM
	DBA_TABLESPACES T,
	DBA_DATA_FILES D 
WHERE
	T.TABLESPACE_NAME = D.TABLESPACE_NAME 
ORDER BY
	T.TABLESPACE_NAME,
	D.FILE_NAME;

只修改表空间最大值

ALTER database DATAFILE 'D:\DataBase\SYSTEM.DBF' autoextend ON maxsize 5000m;

修改表空间最大值及每次自增大小

ALTER database datafile 'D:\DataBase\SYSTEM.DBF' autoextend ON NEXT 200m maxsize 5000m;