SOS!!! I NEED HELP ON OR

AE>ORA-03113 end-of-file on communication channel

AE>They work under ORACLE V6.0.27 under SCO UNIX v3.2.2 with tablespace SYSTEM
AE>( to the point, it's all right in another tablespaces ), though tablespace
AE>SYSTEM is enough free.

Alex, the Oracle messages manual displays ORA-3113 (which you surely have, as it is well known that Russians always pay for their software) as a SQL*Net error. What may be happening is that, if your system tablespace is too fragmented, e.g. if that is where your intermediate runs are going to sort, that the kernel is cannot process the query and this happens to be how it manifests itself.

You are aware that if your system tablespace is fragmented, you must drop and recreate the database?

hth

jh

---
 . MR/2 1.39x NR . Larry is no Oracle!!