Re: FULL JOIN ORA-03113

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?

 Works OK on 9.2.0.5. There were rather a lot of things broken in 9.2.0.1.0, so you may want to go up a few patch levels.

--
Andy Hassall <andy_at_andyh.co.uk> / Space: disk usage analysis tool
http://www.andyh.co.uk         / http://www.andyhsoftware.co.uk/space