2012-09-28

Increase tablespace size in Oracle


>> 2012-09-27 03:48:18 INFO - ProjectTemplateRPCImpl : updateProjectTemplateXML(): errorCode:errorText ::-1691:ORA-01691: LOB-Segment XS.SYS_LOB0000075533C00015$$


...something like this (tablespace is full) might be solved by entering this as a DBA user using sqlplus.

alter database datafile 'C:\app\dev\oradata\dev\MY_FILE_BSDT1.DBF' resize 1000M;
or
alter database datafile 'XXX.dbf' autoextend on next 50M maxsize 2048M;