ORA-03214:File Size specified is smallerthan minimum required问题解决

报错：

ERROR at line 1:

ORA-03214: File Size specified is smallerthan minimum required

这个报错一般先检查下自己的命令是不是没有给定单位

如：

本意  alter ...add datafile ...... size 1024M...;

却写成 alter ...add datafile ...... size 1024 ...;

这样报错就出来了，一般希望创建size极小的数据文件需求基本不会有，如果真有就给稍大一点也就可以了。

其他原因可参考：

Problem Description
-------------------

You are using a database which is based on 8k database blocks.

You create a tablespace and get the following error message:

   SQL> create tablespace verysmall 
     2  datafile '/ora/ora901/oradata/V901/small01.dbf'
     3  size 50k;
   create tablespace verysmall datafile '/ora/ora901/oradata/V901/small01.dbf' 
   *
   ERROR at line 1:
   ORA-03214: File Size specified is smaller than minimum required


Solution Description
--------------------
1. Either increase the size for the datafile :
 
   SQL> create tablespace verysmall
     2  datafile '/ora/ora901/oradata/V901/small01.dbf'
     3  size 88k;

   Tablespace created.

2. Or specify the size of the extent allocation:

   SQL> create tablespace verysmall
     2  datafile '/ora/ora901/oradata/V901/small01.dbf'
     3  size 34k
     4  uniform size 10k;

   Tablespace created.


Explanation
-----------
1. In 9i, when you create a tablespace, it is by default created as a Locally 
   Managed Tablespace with a minimum extent size of 64K, if the local management
   is system managed.

   Therefore, you must allocate size datafiles to 64 Kbytes + 3 blocks for the bitmap blocks.
   In solution 1, the datafile size could not be set less than 64K + (3*8k)= 88k

2. If you supply the UNIFORM parameter, size the datafiles to 3 blocks + one extent size
   minimum. It offers the means to allocate the first extent without problem.
 
   Therefore in solution 2, the datafile cannot be set less than 
   10K + (3*8k) = 34K

   SQL> create tablespace verysmall
     2  datafile '/ora/ora901/oradata/V901/small01.dbf'
     3  size 32k
     4  uniform size 10K;
   create tablespace verysmall
   *
   ERROR at line 1:
   ORA-03214: File Size specified is smaller than minimum required


References
----------

Note:111666.1  Locally Managed Tablespace with Uniform Extent Size Need 64K 
                 Per Datafile
Note:109627.1  Migrating a Tablespace from Dictionary to Locally Managed 
                 Requires Space