java.io.IOException: ORA-01691: unable to extend lob segment
June 20, 2017
Errors/Workarounds-Applications, Oracle APPS DBA
ERROR
Start uploading…
Target file: SAF654_XML.rtf
Creating a new record in XDO_LOBS: SAF645_XML.rtf
java.io.IOException: ORA-01691: unable to extend lob segment XDO.SYS_LOB00001312564V00010$$ by 16 in tablespace APPS_TS_TX_DATA
Target file: SAF654_XML.rtf
Creating a new record in XDO_LOBS: SAF645_XML.rtf
java.io.IOException: ORA-01691: unable to extend lob segment XDO.SYS_LOB00001312564V00010$$ by 16 in tablespace APPS_TS_TX_DATA
at oracle.jdbc.driver.DatabaseError.SQLToIOException(DatabaseError.java:517)
at oracle.jdbc.driver.OracleBlobOutputStream.flushBuffer(OracleBlobOutputStream.java:214)
at oracle.jdbc.driver.OracleBlobOutputStream.write(OracleBlobOutputStream.java:144)
at java.io.BufferedOutputStream.write(BufferedOutputStream.java:105)
at oracle.apps.xdo.oa.schema.server.LobHelper.updateLob(LobHelper.java:133)
at oracle.apps.xdo.oa.schema.server.LobHelper.updateLob(LobHelper.java:291)
at oracle.apps.xdo.oa.schema.server.LobHelper.createLob(LobHelper.java:778)
at oracle.apps.xdo.oa.schema.server.LobHelper.createLob(LobHelper.java:730)
at oracle.apps.xdo.oa.util.XDOLoader.processUpload(XDOLoader.java:1163)
at oracle.apps.xdo.oa.util.XDOLoader.process(XDOLoader.java:1003)
at oracle.apps.xdo.oa.util.XDOLoader.main(XDOLoader.java:2251)AD Worker error:
The above program failed. See the error messages listed
above, if any, or see the log and output files for the program.
at oracle.jdbc.driver.OracleBlobOutputStream.flushBuffer(OracleBlobOutputStream.java:214)
at oracle.jdbc.driver.OracleBlobOutputStream.write(OracleBlobOutputStream.java:144)
at java.io.BufferedOutputStream.write(BufferedOutputStream.java:105)
at oracle.apps.xdo.oa.schema.server.LobHelper.updateLob(LobHelper.java:133)
at oracle.apps.xdo.oa.schema.server.LobHelper.updateLob(LobHelper.java:291)
at oracle.apps.xdo.oa.schema.server.LobHelper.createLob(LobHelper.java:778)
at oracle.apps.xdo.oa.schema.server.LobHelper.createLob(LobHelper.java:730)
at oracle.apps.xdo.oa.util.XDOLoader.processUpload(XDOLoader.java:1163)
at oracle.apps.xdo.oa.util.XDOLoader.process(XDOLoader.java:1003)
at oracle.apps.xdo.oa.util.XDOLoader.main(XDOLoader.java:2251)AD Worker error:
The above program failed. See the error messages listed
above, if any, or see the log and output files for the program.
Time when worker failed: Thu Nov 12 2014 12:54:12
Manager says to quit.
Time when worker quit: Thu Nov 12 2014 12:54:32
Connecting to APPS……Connected successfully.AD Worker is complete.
SOLUTION
Connect to database as System user
SQL>alter database datafile ‘/u01/apps/db/apps_st/data/a_txn_data02.dbf’ resize 3000M
Related Posts