請(qǐng)教oracle10g 塊大小問(wèn)題

the2rdpiece

最近Oracle數(shù)據(jù)庫(kù)換成了10g，之前在9i上，雖然安裝數(shù)據(jù)庫(kù)默認(rèn)的塊大小是16k，但是可以建立表空間的時(shí)候，指定塊大小是32k的，但是現(xiàn)在換成10g后，第1條sql正確，而第2條就會(huì)報(bào)錯(cuò)，這個(gè)是為啥呢，是我設(shè)置不對(duì)么：

1、create tablespace tbs_dim_idx  nologging datafile '/dev/vg04/rlv_vg04_8g_0006' blocksize 16k extent management local uniform size 32m segment space management auto;

2、create tablespace tbs_dim_fact nologging datafile '/dev/vg04/rlv_vg04_8g_0007' blocksize 32k extent management local uniform size 64m segment space management auto;

tacsoft

本文摘自
Oracle® Database Administrator's Guide
10g Release 2 (10.2)
Part Number B14231-02

指定非標(biāo)準(zhǔn)塊體積表空間(Specifying Nonstandard Block Sizes for Tablespaces)

你可以創(chuàng)建塊體積與標(biāo)準(zhǔn)數(shù)據(jù)庫(kù)塊不同的表空間，指定DB_BLOCK_SIZE初始化參數(shù)。這個(gè)特性使你在數(shù)據(jù)庫(kù)之間傳輸塊大小不同的表空間。
（You can create tablespaces with block sizes different from the standard database block size, which is specified by the DB_BLOCK_SIZE initialization parameter. This feature lets you transport tablespaces with unlike block sizes between databases.）

使用CREATE TABLESPACE語(yǔ)句的BLOCKSIZE子句創(chuàng)建不同于數(shù)據(jù)庫(kù)標(biāo)準(zhǔn)塊體積的表空間。為了使BLOCKSIZE子句成功使用，你必須先設(shè)置DB_CACHE_SIZE和至少有一個(gè)DB_nK_CACHE_SIZE初始化參數(shù)。此外，你指定的BLOCKSIZE子句必須與DB_nK_CACHE_SIZE初始化參數(shù)對(duì)應(yīng)。盡管是多余的，指定BLOCKSIZE等于標(biāo)準(zhǔn)塊體積，如同指定DB_BLOCK_SIZE 初始化參數(shù)，是允許的。
（Use the BLOCKSIZE clause of the CREATE TABLESPACE statement to create a tablespace with a block size different from the database standard block size. In order for the BLOCKSIZE clause to succeed, you must have already set the DB_CACHE_SIZE and at least one DB_nK_CACHE_SIZE initialization parameter. Further, and the integer you specify in the BLOCKSIZE clause must correspond with the setting of one DB_nK_CACHE_SIZE parameter setting. Although redundant, specifying a BLOCKSIZE equal to the standard block size, as specified by the DB_BLOCK_SIZE initialization parameter, is allowed.）

下面語(yǔ)句創(chuàng)建表空間lmtbsb，但是指定的塊體積不同于標(biāo)準(zhǔn)數(shù)據(jù)庫(kù)塊（如同指定DB_BLOCK_SIZE初始化參數(shù)）：
（The following statement creates tablespace lmtbsb, but specifies a block size that differs from the standard database block size (as specified by the DB_BLOCK_SIZE initialization parameter):）

例子：
CREATE TABLESPACE lmtbsb DATAFILE '/u02/oracle/data/lmtbsb01.dbf' SIZE 50M
    EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K
    BLOCKSIZE 8K;

gguxxing008

LS的幫頂！

the2rdpiece

噢，謝謝了，原來(lái)如此