為lob型別分配extents

首先查詢 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@]