Friday, July 11, 2014

ORA-01114

ORA-00603: ORACLE server session terminated by fatal error
ORA-24557: error 1114 encountered while handling error 1114; exiting server process
ORA-01114: IO error writing block to file 204 (block # 76928)


ERROR at line 1:
ORA-12801: error signaled in parallel query server P037
ORA-01114: IO error writing block to file (block # )
ORA-01114: IO error writing block to file 1527 (block # 3126400)
ORA-27072: File I/O error
Additional information: 4
Additional information: 3126400
Additional information: -1 



Hit above error, even run  a small query irregardless off 300GB TEMP space.

Please refer to my reply here