ORA-02494: MAXSIZE 子句中的最大文件大小无效或缺少

ORA-02494: MAXSIZE 子句中的最大文件大小无效或缺少 

SELECT UPPER(F.TABLESPACE_NAME) "tablespace name",

D.TOT_GROOTTE_MB "tablespace(M)",

D.TOT_GROOTTE_MB - F.TOTAL_BYTES "used(M)",

TO_CHAR(ROUND((D.TOT_GROOTTE_MB - F.TOTAL_BYTES) / D.TOT_GROOTTE_MB * 100,2),'990.99') "used%",

F.TOTAL_BYTES "free(M)",

F.MAX_BYTES "max big block(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;

发现used% = 99.87%

RAC下添加数据文件

SQL>alter tablespace ts_felix add datafile '+DATA/orcl/datafile/ts_felix02.dbf' size 8192m autoextend on next 128m maxsize 8192m;

SQL>alter tablespace ts_felix add datafile '+DATA/orcl/datafile/ts_felix02.dbf' size 8192m autoextend on next 128m maxsize unlimited;

ORA-02494: MAXSIZE 子句中的最大文件大小无效或缺少

 

SQL>alter tablespace ts_felix add datafile size 8192m autoextend on next 128m maxsize 8192m;

SQL>select file_name from dba_data_files;