Shulou(Shulou.com)05/31 Report--

This article mainly introduces how to create a non-default block size tablespace in the database, which is very detailed and has a certain reference value. Friends who are interested must read it!

SQL > create tablespace ts16k

2 datafile'C:\ app\ Administrator\ oradata\ orcl\ ts16k.dbf'

3 size 50m blocksize 16k

Create tablespace ts16k

*

ERROR at line 1:

ORA-29339: tablespace block size 16384 does not match configured block sizes

SQL > show parameter block

NAME TYPE VALUE

-

Db_block_buffers integer 0

Db_block_checking string FALSE

Db_block_checksum string TYPICAL

Db_block_size integer 8192

Db_file_multiblock_read_count integer 128

SQL > show parameter db_16k_cache_size

NAME TYPE VALUE

-

Db_16k_cache_size big integer 0

SQL > alter system set db_16k_cache_size=100m

System altered.

SQL > create tablespace ts16k

2 datafile'C:\ app\ Administrator\ oradata\ orcl\ ts16k.dbf'

3 size 10m blocksize 16k

Tablespace created.

SQL >

These are all the contents of the article "how to create non-default block size tablespaces in a database". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.