首先查询 dba_lobs得到相关信息。

SQL> select table_name,column_name,segment_name from dba_lobs where table_name='ESB_MF_INFORMATION';

TABLE_NAME COLUMN_NAME SEGMENT_NAME
-------------------- ------------------------- -------------------------------------------------------
ESB_MF_INFORMATION EXCEPTION_DATA SYS_LOB0000078584C00009$$
ESB_MF_INFORMATION RUNTIME_EXCEPTION SYS_LOB0000078584C00008$$

然后根据出来的信息

alter table ESBAGENT.ESB_MF_INFORMATION modify lob (EXCEPTION_DATA)

(allocate extent (size 1024m))

[@more@]

ITPub博客

为lob类型分配extents

最新文章