- 论坛徽章:
- 0
|
本文摘自
Oracle® Database Administrator's Guide
10g Release 2 (10.2)
Part Number B14231-02
指定非标准块体积表空间(Specifying Nonstandard Block Sizes for Tablespaces)
你可以创建块体积与标准数据库块不同的表空间,指定DB_BLOCK_SIZE初始化参数。这个特性使你在数据库之间传输块大小不同的表空间。
(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语句的BLOCKSIZE子句创建不同于数据库标准块体积的表空间。为了使BLOCKSIZE子句成功使用,你必须先设置DB_CACHE_SIZE和至少有一个DB_nK_CACHE_SIZE初始化参数。此外,你指定的BLOCKSIZE子句必须与DB_nK_CACHE_SIZE初始化参数对应。尽管是多余的,指定BLOCKSIZE等于标准块体积,如同指定DB_BLOCK_SIZE 初始化参数,是允许的。
(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.)
下面语句创建表空间lmtbsb,但是指定的块体积不同于标准数据库块(如同指定DB_BLOCK_SIZE初始化参数):
(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; |
|