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

posted on 2012-08-02 13:16  子虚乌有  阅读(243)  评论(0)    收藏  举报