ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 创建不通尺寸表空间

创建不通尺寸表空间

原创 Linux操作系统 作者:不吹牛能死 时间:2012-11-15 11:35:43 0 删除 编辑

SQL> select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 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>
SQL> create tablespace zyp datafile '/home/oracle/zyp.dbf' size 10M blocksize 16k;
create tablespace zyp datafile '/home/oracle/zyp.dbf' size 10M blocksize 16k
*
ERROR at line 1:
ORA-29339: tablespace block size 16384 does not match configured block sizes


SQL> !
[oracle@ora11 ~]$ oerr ora 29339
29339, 00000, "tablespace block size %s does not match configured block sizes"
// *Cause:  The block size of the tablespace to be plugged in or
//          created does not match the block sizes configured in the
//          database.
// *Action:Configure the appropriate cache for the block size of this
//         tablespace using one of the various (db_2k_cache_size,
//         db_4k_cache_size, db_8k_cache_size, db_16k_cache_size,
//         db_32K_cache_size) parameters.
[oracle@ora11 ~]$ exit
exit

SQL> show parameter cache_size;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
client_result_cache_size             big integer 0
db_16k_cache_size                    big integer 0
db_2k_cache_size                     big integer 0
db_32k_cache_size                    big integer 0
db_4k_cache_size                     big integer 0
db_8k_cache_size                     big integer 0
db_cache_size                        big integer 0
db_flash_cache_size                  big integer 0
db_keep_cache_size                   big integer 0
db_recycle_cache_size                big integer 0
SQL>
SQL>
SQL> alter system set db_16k_cache_size=10M scope=both;


SQL> create tablespace zyp datafile '/home/oracle/zyp.dbf' size 20M blocksize 16k;

Tablespace created.

SQL> create tablespace zyp_1 datafile '/home/oracle/zyp_1.dbf' size 30M blocksize 16k;

Tablespace created.

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/28278387/viewspace-749254/ ,如需转载,请注明出处,否则将追究法律责任。

下一篇: 一次tns故障处理
请登录后发表评论 登录
全部评论

注册时间:2012-10-17

  • 博文量
    22
  • 访问量
    28054