Question

如何修改oracle数据块的大小

Answer 1

数据库的表空间的block size建立好之后就不能修改，要么新建一个表空间，或者新建数据库，然后将数据导入到新的数据库。

Answer 2

tablespace can have different block sizes in a database
SQL> alter system set db_2k_cache_size=1024k;
System altered
SQL> alter system set db_16k_cache_size=1024k;
System altered.
SQL> alter system set db_8k_cache_size=1024k;
System altered.
SQL> CREATE TABLESPACE tbs_test_2k
2 DATAFILE 'C:ORACLEORADATATEST\tbs_test_2k_01.dbf' SIZE 10M
3 EXTENT MANAGEMENT LOCAL
4 UNIFORM SIZE 256K
5 blocksize 2k;
Tablespace created.
SQL> CREATE TABLESPACE tbs_test_8k
2 DATAFILE 'C:ORACLEORADATATEST\tbs_test_8k_01.dbf' SIZE 10M
3 EXTENT MANAGEMENT LOCAL
4 UNIFORM SIZE 256K
5 blocksize 8k;
Tablespace created.
SQL> CREATE TABLESPACE tbs_test_16k
2 DATAFILE 'C:ORACLEORADATATEST\tbs_test_16k_01.dbf' SIZE 10M
3 EXTENT MANAGEMENT LOCAL
4 UNIFORM SIZE 256K
5 blocksize 16k;
Tablespace created.

Answer 3

改变不了

Answer 4

重新建库,数据迁移