ORA-01691

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

Cause: Failed to allocate an extent of the required number of blocks for LOB segment in the tablespace indicated.

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

alert.log
Wed Sep 24 13:01:06 2008
ORA-1691: unable to extend lobsegment APP_DAW.SYS_LOB0000488635C00008$$ by 64 in tablespace APP_DAW_TABLES

If the datafiles of the tablespace are set to auto extend, the reason is that the datafiles have reached its maximum size. The following scripts can be used to check and increase the size:


1- For Non TEMP tablespaces :

SELECT file_name,bytes,autoextensible,maxbytes 
FROM dba_data_files 
WHERE tablespace_name='XX';

2- For TEMP Tablespaces :

SELECT file_name,bytes,autoextensible,maxbytes 
FROM dba_temp_files 
WHERE tablespace_name=' XX'; 

1- For datafiles :

 Change the datafiles attributes to be autoextensible without the maxbytes file size limitation by setting the MAXBYTES column to unlimited as follows :


SQL> alter database datafile '' autoextend on maxsize unlimited;



2- For Temp files :

SQL> alter database tempfile '' autoextend on maxsize unlimited;

--------------------------------------------------

All Oracle errors in the blog can be found at: Oracle errors
All ESRI ArcSDE errors in the blog can found at: ArcSDE Errors