ORA-03113: End of File on Communication Channel

[Ovidiu Maftei]

Hello guys, I have an unexpected problem with this error. It appears when I execute and select statement showing bellow.  The strange things is until now I don't catch it  nevermore. I use two RDBMS: Oracle 8.1.7 EE for Windows NT4 and  Oracle 8.1.7 EE for HPUX.   The select  statemen is: select tgr_error_id, count(tgr_error_id) from tim_logger where (TGR_CODICE_ID, TGR_DATETIME) not in (select tgr_codice_id, max(tgr_datetime) from tim_logger group by tgr_codice_id) and tgr_error_id<>'000' group by tgr_error_id order by tgr_error_id The table is: TABLE TIM_LOGGER ( TGR_ID NUMBER, TGR_CODICE_ID VARCHAR2 (14), TGR_DATETIME DATE, TGR_ERROR_ID CHAR (3))   Thanks