安装 opencms, 碰到 ORA-03252: initial extent size not enough for LOB segment

安装OpenCMS 到 oracle 指定 tablespace 时遇到 如下问题

Caused by: java.io.IOException: ORA-03252: initial extent size not enough for LOB segment

数据库：oracle 11g

其中 default tablespace 500MB,  index tablespace 300MB.

opencms: 8.5.1

 

分析：OpenCMS 用自带的 script 取建立table的时候，指定了CHUNK size 为32K， 过大了！ 修改为16K 后安装成功！

 

具体修改如下：

编辑 %OPENCMS/setup/database/oracle/create_tables.sql

修改一下两个地方：

CREATE TABLE CMS_OFFLINE_CONTENTS (
    RESOURCE_ID VARCHAR2(36) NOT NULL,
    FILE_CONTENT BLOB NOT NULL,
    CONSTRAINT PK_OFFLINE_CONTENTS PRIMARY KEY(RESOURCE_ID) USING INDEX TABLESPACE ${indexTablespace}
)
STORAGE (INITIAL 256K NEXT 1M PCTINCREASE 0)
    LOB(FILE_CONTENT) STORE AS (
        CHUNK 32K PCTVERSION 20  
        CACHE
);

CREATE TABLE CMS_CONTENTS (
    RESOURCE_ID VARCHAR2(36) NOT NULL,
    FILE_CONTENT BLOB NOT NULL,
    PUBLISH_TAG_FROM INT,
    PUBLISH_TAG_TO INT,
    ONLINE_FLAG INT,
    CONSTRAINT PK_CONTENTS PRIMARY KEY(RESOURCE_ID, PUBLISH_TAG_FROM) USING INDEX TABLESPACE ${indexTablespace}
)
STORAGE (INITIAL 256K NEXT 1M PCTINCREASE 0)
    LOB(FILE_CONTENT) STORE AS (
        CHUNK 32K PCTVERSION 20 
        CACHE
);