ora-03206问题的解决

客户 11.2.0.3.0 RAC 添加数据文件，报错ora-03206

 

alter tablespace users add datafile '*****/***/*' size 31744m next 10240m maxsize 102400m;

 *

ERROR at line 1:

ORA-03206: maximum file size of (13107200) blocks in AUTOEXTEND clause is out of range

 

当前所有表空间都使用默认的block size 8k

SQL> select inst_id,name,bigfile from gv$tablespace;

 

   INST_ID NAME                           BIG

---------- ------------------------------ ---

         2 SYSTEM                         NO

         2 SYSAUX                         NO

         2 UNDOTBS1                       NO

         2 USERS                          NO

         2 TEMP                           NO

         2 UNDOTBS2                       NO

         1 SYSTEM                         NO

         1 SYSAUX