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