时间戳

首页 > 解决方案 > 在 Db2 中创建 LOB 表空间

db2 - 在 Db2 中创建 LOB 表空间

问题描述

我正在运行下面提到的用于创建 LOB 表空间的查询，但出现错误。任何人都可以检查为什么会出现这个错误。

询问 ：-

CREATE LOB TABLESPACE RESUMETS IN BLUDB LOG NO CLOSE NO;

错误 ：-

SQL> CREATE LOB TABLESPACE RESUMETS IN BLUDB LOG NO;
ERROR near line 1:
SQL0104N  An unexpected token "CREATE LOB TABLESPACE" was found following
 "BEGIN-OF-STATEMENT".  Expected tokens may include:  "<select>".

Error :- 

db2 =>  CREATE LOB TABLESPACE RESUMETS IN BLUDB LOG NO CLOSE NO
DB21034E  The command was processed as an SQL statement because it was not a
valid Command Line Processor command.  During SQL processing it returned:
SQL0104N  An unexpected token "CREATE LOB TABLESPACE" was found following
"BEGIN-OF-STATEMENT".  Expected tokens may include:  "<select>".
SQLSTATE=42601

标签： db2tablespacelob

解决方案

在 DB2 for Linux、Unix 和 Windows 中没有“LOB 表空间”这样的东西。请参阅CREATE TABLESPACE此处的文档。

https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.sql.ref.doc/doc/r0000929.html

推荐阅读