首先查询 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博客 ” ,链接:http://blog.itpub.net/24237320/viewspace-1059131/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/24237320/viewspace-1059131/