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
Post a Comment