在Oracle中增加BLOB数据类型的大小的语法是什么? [英] What is the syntax for increasing the size of a BLOB datatype in Oracle?

问题描述

医生说:

ALTER TABLE <table name>

ADD (<lobcol> <LOBTYPE> <LOB_clause_same_as_for_create>) |

MODIFY LOB (<lobcol>) (

            [PCTVERSION <version_number>]

            [ { CACHE | NO CACHE [{LOGGING | NOLOGGING}]

                      | CACHE READS [{LOGGING | NOLOGGING}]

              }

            ]

) |

MOVE [ONLINE] [<physical_attributes>] [TABLESPACE <tablespace_name>]

[LOGGING | NOLOGGING] [<LOB_clause_same_as_for_create>]

以以下示例为例:

ALTER TABLE test_lob

MODIFY LOB (image) (

    STORAGE (NEXT 1M)

    CACHE

);

我尝试使用表名和列名:

I tried this with my table and column names:

ALTER TABLE  <table name>

MODIFY LOB (<column name>) (

    STORAGE (NEXT 10M)

);

但是我得到了范围参数不允许的ORA-25150更改错误.

But I get an ORA-25150 ALTERING of extent parameters not permitted error.

我在做什么错了?

推荐答案

您的代码中缺少表名

ALTER TABLE

MODIFY LOB (<column name>) (
STORAGE (NEXT 10M)

);

应该是

ALTER TABLE TABLE_NAME
MODIFY LOB (<column name>) (

STORAGE (NEXT 10M)

);

这篇关于在Oracle中增加BLOB数据类型的大小的语法是什么?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！