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