30 September 2010

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

Start uploading...
Target file: FAS444_XML.rtf
Creating a new record in XDO_LOBS: FAS444_XML.rtf
java.io.IOException: ORA-01691: unable to extend lob segment XDO.SYS_LOB0000332070C00010$$ 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 Sep 30 2010 20:10:10


Manager says to quit.


Time when worker quit: Thu Sep 30 2010 20:13:12

Connecting to APPS......Connected successfully.

AD Worker is complete.

solution :-

conn as system user

SQL>alter database datafile '/oracle/PROD/db/apps_st/data/a_txn_data01.dbf' resize 4000M

No comments: