ORA-03214: File size specified is smaller than minimum required

SQL> alter database datafile '+DATA/MYDB/19AF24AD633634AEE0632502F50A727A/DATAFILE/testtbs.5971.1170569741' resize 6m;  alter database datafile '+DATA/MYDB/19AF24AD633634AEE0632502F50A727A/DATAFILE/testtbs.5971.1170569741' resize 6m  *  ERROR at line 1:  ORA-03214: File size specified is smaller than minimum required

This error may be returned when you are creating a new tablespace, adding a datafile to a tablespace, or reducing the size of a datafile using the "ALTER DATABASE DATAFILE RESIZE" command. Error description clearly displays the reason. For a big file tablespace of 8k block, the minimum datafile size could be 7MB. For 32k block size, minimum datafile size required is 12 MB. For a small file tablespace, you can even create datafiles with less than 1MB size.  

Oracle Big Datafile Tablespaces

SQL> create bigfile tablespace bigtbs datafile 'd:\bigtbs.dbf' size 100m;     Tablespace created.

You can set default tablesapce type database_properties as follows. 

SQL> select property_name,property_value from database_properties where property_name='DEFAULT_TBS_TYPE';     PROPERTY_NAME                  PROPERTY_VALUE  ------------------------------ ----------------------------------------  DEFAULT_TBS_TYPE               SMALLFILE     SQL> ALTER DATABASE SET DEFAULT BIGFILE TABLESPACE;     Database altered.     SQL> select property_name,property_value from database_properties where property_name='DEFAULT_TBS_TYPE';     PROPERTY_NAME                  PROPERTY_VALUE  ------------------------------ ----------------------------------------  DEFAULT_TBS_TYPE               BIGFILE