ora-01691 error no space
Today, When i come to company,check the result what i run yesterday. but there some error. as follow:
ORA-01691 unable to extend lob segment string.string by string in tablespace string
so we check tablespace use toad(Database->administer->tablespace),found that the space is full. so we need add some new space for the tablespace. in my case, attribute 'Maxinum size unlimited' and 'Auto extend' is not use.
there two ways solve it:
1:ALTER DATABASE
DATAFILE 'D:\DATA\ORACLE\service_HOME\ORADATA\LOB01.DBF'
AUTOEXTEND ON
NEXT 32M
MAXSIZE UNLIMITED;
2:alter tablespace
spacename
add datafile 'D:\DATA\ORACLE\service_HOME\ORADATA\LOB02.DBF'
size 10204m
autoextend on
next 1024m
maxsize 40960M