ORA-03113: end-of-file on communication channel ON Oracle 8.0.4

From: Valentin Mînzatu <mvali_at_rds.ro>
Date: Tue, 14 Dec 1999 15:50:48 +0200
Message-ID: <38564B38.C58F20A_at_rds.ro>

Is there anybody who knows what can I do to avoid this "misterious" Oracle message that cause me a lot of problems ?

Here is what I do:

    I have a package that do more operations. I have a procedure that do some INSERTs and DELETEs and TRUNCATEs and UPDATEs on three tables. Two of these tables are INDEX-ORGANIZED. I do a lot of INSERTs, DELETEs and TRUNCATEs on them inside of a LOOP that is independent of datas in those tables (Ex: FOR i IN 1..4 LOOP ...).
  Somewhere, inside the loop, the link crashes "unexplained" (without any Oracle error) and I cannot continue.   I have planty of COMMITs inside the loop, so the rollback segment grows too much is not an explanation.
  All of these on Oracle Server 8.0.4 Enterprise Edition.

The funny part comes right now: on other server (same ORACLE 8.0.4 - not Enterprise) the procedure works perfectly.

Any ideas would be appreciated,
Thanks,

Vali Received on Tue Dec 14 1999 - 14:50:48 CET