Oracle Temp Space Issues

Error 1- Getting ORA-01654: unable to extend index <index name> by 5 in tablespace <tablespace name> 
Error 2- While trying to Check-in/out, the following error occurs:
23:9:17 I00060052: Check Access execution was successful.
E03020003: Database error [CAI/PT][ODBC Oracle Dynamic driver][Oracle]ORA-01653: unable to extend table HARAMX.HARVERSIONS by 5 in tablespace HARVESTBLOB
Error 3- Getting the following error: 
ORA-01688: Unable to Extend <Table Name> <Partition Name> by 5 in <Tablespace Name>

Error 4 -Io exception: End of TNS data channel

Error 5 - SQL state [64000]; error code [1114]; ORA-01114: IO error writing block to file 1005 (block # 77047)
ORA-27072: File I/O error
Additional information: 4
Additional information: 77047
Additional information: 8192
ORA-01114: IO error writing block to file 1005 (block # 77047)
ORA-27072: File I/O error
Additional information: 4
Additional information: 77047
Additional information: 8192;

nested exception is java.sql.SQLException: ORA-01114: IO error writing block to file 1005 (block # 77047)

If you are getting the above errors while running your Application then there is a high Probability that there is less Temporary Space in your Database User.  
You will be required to Increase your Temp Space which can be done by DBA.

To get more info about temp space go through following link

Idevelopment- Resizing Temporary Tablespace

Oracle-Altering Tablespace Availability








Comments

Popular Posts