Re: FULL JOIN ORA-03113

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Tue, 13 Apr 2004 20:22:18 +1000
Message-ID: <opr6d4fgvz3d8uqx@news.optusnet.com.au>

On Tue, 13 Apr 2004 13:00:11 +0400, ÷ÁÄÉÍ íÉÇÕÎÏ× <migunov_at_radico.ru> wrote:

> Hi, there is something wrong with FULL JOIN. Win 2000, Oracle9i
> Enterprise
> Edition Release 9.2.0.1.0 - Production. ORA-03113: end-of-file on
> communication channel.
> Example:
> select * from dba_objects o1 full join dba_objects o2
> on o1.object_id = o2.object_id
>
> I've tried it many times on different servers DB and result ORA-03113:
> end-of-file on communication channel.
>
> Can anyone say something of it?

What, apart from the fact that performing a self-full-join makes no sense?

Regards
HJR

-- 
-------------------------------------------
Dizwell Informatics: http://www.dizwell.com
  -A mine of useful Oracle information-
          -Windows Laptop Rac-
    -Oracle Installations on Linux-
===========================================

Received on Tue Apr 13 2004 - 05:22:18 CDT