在 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

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

最新更新