ORA-01691 解决方法

 

　　ORA-01691: unable to extend lob segment BPM49_TEST2.SYS_LOB0000059105C00008$$ by 128 in tablespace JACK_DATA

 

　　下面是oracle官方??代?

ORA-01691 unable to extend lob segment string.string by string in tablespace string

Cause: Failed to allocate an extent for LOB segment in tablespace.

Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.

下面是解决方法

方法1：修改数据文件的?展性

alter database datafile '文件路径' autoextend on next 100m maxsize 4000M;

方法2：?表空?增加新的数据文件

alter tablespace jack_data add datafile '数据文件路径‘ size 1000m autoextend on next 100m maxsize 4000M;

--alter tablespace IFAMEX_BLOB online
--alter tablespace IFAMEX_BLOB rename datafile 'C:/DATA/HJCBFW01/BLOB01.DBF' to 'D:/DATA/HJCBFW01/BLOB01.DBF'
--alter tablespace IFAMEX_BLOB add datafile 'C:/DATA/HJCBFW01/BLOB02.DBF' size 200m autoextend on next 10m maxsize 2000m