ORA-03249: Automatic segment Space management must have at least 5 blocks of tablespace size

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.