java.sql.SQLException: ORA-01654: unable to extend index DEV3_SOAINFRA.COMPOSITE_INSTANCE_STATE by 8 in tablespace DEV3_SOAINFRA[[

if you are hitting anything like the below issues or similar to the below issues then this may be because of dbf file size issues

Issues:
java.sql.SQLException: ORA-01654: unable to extend index DEV3_SOAINFRA.COMPOSITE_INSTANCE_STATE by 8 in tablespace DEV3_SOAINFRA[[

oracle.toplink.exceptions.DatabaseException[[
Internal Exception: java.sql.BatchUpdateException: ORA-01691: unable to extend lob segment DEV3_SOAINFRA.SYS_LOB0000129222C00018$$ by 8 in tablespace DEV3_SOAINFRA

Solution: to extend datafile/dbf file size by 4gb
ALTER DATABASE DATAFILE ‘db1300/oradata/db1300/DB1300_soainfra.dbf’ RESIZE 4000M;

NOTE: make sure you take a backup of dbf files before executing above alter command

if the file got corrupted then u may have to recreat the file then use bleow command to recreate it

ALTER TABLESPACE DEV3_SOAINFRA ADD DATAFILE ‘db1300/oradata/db1300/DB1300_soainfra.dbf’ SIZE 4000M
AUTOEXTEND ON
NEXT 512K
MAXSIZE 250M;


refernce to some of the good material
http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_3002.htm

http://docs.oracle.com/cd/B10500_01/server.920/a96521/tspaces.htm

http://www.idevelopment.info/data/Oracle/DBA_tips/Tablespaces/TBS_3.shtml