ORA-03249: automatic segment space management of the tablespace size should have at least 5 blocks, ora-03249 space size
Create a tablespace for a test and report an error.
SQL> select * from v $ version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Production
PL/SQL Release 11.2.0.1.0-Production
CORE 11.2.0.1.0 Production
TNS for Linux: Version 11.2.0.1.0-Production
NLSRTL Version 11.2.0.1.0-Production
SQL> create tablespace TBS_A datafile '/oracle/oradata/lcamtest/tbs_a.dbf' size 1 M autoextend on uniform size 64 k;
Create tablespace TBS_A datafile '/oracle/oradata/lcamtest/tbs_a.dbf' size 10 M autoextend on uniform size 64 k
*
Row 3 has an error:
ORA-03249: The tablespace size for automatic segment space management should have at least 5 blocks
Autoextend on uniform size,It indicates that the size of all EXTENT allocated by the tablespace is specified. For automatic SEGMENT management, it is required that at least five blocks of table headers are EXTENT. The solution is to change the uniform size to at least five times the db_block_size.
SQL> show parameter db_block_size
NAME TYPE VALUE
-----------------------------------------------------------------------------
Db_block_size integer 16384
SQL> create tablespace TBS_A datafile '/oracle/oradata/lcamtest/tbs_a.dbf' size 1 M autoextend on uniform size 128 k;
The tablespace has been created.