oracle block 和windows 簇

最新推荐文章于 2024-10-17 15:50:29 发布

njcw666

最新推荐文章于 2024-10-17 15:50:29 发布

阅读量1k

点赞数

分类专栏： oracle 文章标签： oracle windows database file os

本文链接：https://blog.csdn.net/njcw666/article/details/1745672

版权

oracle 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

在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