ORA-03113: End of File on Communication Channel

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ovidiu Maftei
  INET: maf_at_esolutions.ro

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).