Temp Tablespace unable to extend
Hi,
we have problem with temp tablespace,we are getting the following error
ORA-01114: IO error writing block to file 1025 (block # 1292425)
ORA-27063: skgfospo: number of bytes read/written is incorrect
temp tablespace size 10 gb.
we have verified the v$sort_usage to find the any other parallel transaction is running,but we don't find it.we have bounced the database, but again we face the simlar issue.
It is simple join opertaion query.
Now records in the table
Table1 = 100000
table2 = 200000
After consulted my DBA, he recreated the temp tablespace of same size once again. Same query executed sucessfully after recreating the temp tablespace
What could be problem on this ?
Regards,
Adhavan