oracle block 和windows 簇

来源:互联网 发布:sql 统计项目函数 编辑:程序博客网 时间:2024/05/24 04:34

在oracle8i进行全库倒入时发生了
IMP-00017: following statement failed with ORACLE error 3206:
 "CREATE TABLESPACE "ROLLBACK" DATAFILE  'D:/ORACLE/ORADATA/ORCL/ORARBS."
 "DBF' SIZE 2430M       AUTOEXTEND ON NEXT 10485760  MAXSIZE 32767M DEFAULT  "
 "STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505 PCTINCREASE 50"
 ") ONLINE PERMANENT "
IMP-00003: ORACLE error 3206 encountered
ORA-03206: maximum file size of (8388352) blocks in AUTOEXTEND clause is out of range
经过反复试验发现在oracle8i建库时有一个参数block_size大小在2k-32k之间


操作系统支持的db_block_size,这样来决定:

Database Block
·Minimum unit of I/O
·Consists of one or more OS blocks
·Set at tablespace creation
·DB_BLOCK_SIZE is the default block size