Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

Blog Post

java.io.IOException: ORA-01691: unable to extend lob segment

java.io.IOException: ORA-01691: unable to extend lob segment

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   

     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.

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
Write a comment