Do a test need to build a table space, 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 1M autoextend on uniform size 64k;
Create tablespace tbs_a datafile '/oracle/oradata/lcamtest/tbs_a.dbf ' size 10M autoextend on uniform size 64k
*
line 1th Error:
ORA-03249: Automatic segment Space management should have at least 5 blocks of tablespace size
autoextend on uniform size, refers to the size of all extent of a tablespace allocation is the specified value, for segment automatic management, requires at least 5 blocks above the table header extent. The workaround is to change the uniform size to at least 5 times 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 1M autoextend on uniform size 128k;
The tablespace has been created.
ORA-03249: Automatic segment Space management must have at least 5 blocks of tablespace size