Description:
You attempt to perform a check in and you get Oracle error something like below....
E03020003: Database error [CAI/PT][ODBC Oracle Dynamic
driver][Oracle]ORA-01691: unable to extend lob segment
CA_SCM.SYS_LOB0000055283C00012$$ by 8192 in tablespace HARVESTBLOB
The error is in the tablespace HARVESTBLOB, but you will also need to check tablespaces like TEMP and SYSTEM as well.
You will need to involve a DBA person to increase the space.
You can run the following SQL database query to determine the space available in all your data files:
set feedback off set pagesize 66 column "Tablespace Name" format a19 column "Used" format 99999990 justify right column "Free" format 99999990 justify right column "% Free" format 999.9 justify right column "File Name (Size)" format a30 select y.tablespace_name "Tablespace Name", y.file_name || ' (' || max(y.bytes) / 1024 || 'K)' "File Name (Size)", max(y.bytes) / 1024 - nvl(max(x.bytes),0) / 1024 "Used", nvl(max(x.bytes),0) / 1024 "Free", nvl(max(x.bytes),0) / max(y.bytes) * 100 " Free%" from sys.dba_data_files y, sys.dba_free_space x where y.tablespace_name = x.tablespace_name(+) and y.file_id = x.file_id(+) group by y.tablespace_name, y.file_name;
Tablespace Name File Name (Size) Used Free Free% ------------------------- --------------------------------------------------- --------- --------- ------ USERS C:\ORACLEXE\ORADATA\XE\USERS.DBF (102400K) 1664 100736 98.4 HARVESTMETA C:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DATABASE\HARVESTMETA.ORA (51200K) 8896 42304 82.6 HARVESTBLOB C:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DATABASE\HARVESTBLOB.ORA (51200K) 29760 21440 41.9 SYSTEM C:\ORACLEXE\ORADATA\XE\SYSTEM. DBF (358400K) 353344 5056 1.4
HARVESTINDEX C:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DATABASE\HARVESTINDEX.ORA (51200K) 9408 41792 81.6