You attempt to perform a checkin and you get 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
Solution:
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 that will lists the space available in all
your data files:
1) Login to sqlplus with the user id and password of the owner of the
Harvest tables and run the following:
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;
2) It will provide an output similar to this.
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
3) From the output, see HARVESTBLOB , HARVESTMETA and HARVESTINDEX for
the Free% column. If any of the tablespaces are low (< 25%), then the DBA needs
to extend the tablespace. Also check the physical hard drive disk space to insure it
will accomodate the extension.
Note:
As a result of this problem, you may also have the package that you were trying to check files into
locked. You will then have to use hpkgunlk commandline to unlock the package. Insure no one is
trying to do Harvest transactions at the time of these changes are being made.
This is not a Harvest problem, it is a space problem defined in Oracle.