What can cause an ORA-03113 error?
Date: 1995/06/02
Message-ID: <D9KIz8.JwM_at_freenet.carleton.ca>#1/1
I have two tables which should have a one to one relationship. On occasion
some records in one of the tables is orphaned. In order to track these
and correct the situation I can run a simple query like:
select
Resolution_id is the primary key of the solutions table.
This works fine. However if I change the order by to order by 1 asc my
connection to the database is lost when I receive this error -
ERROR:
Column 1 is not indexed so clearly the difference is that Oracle 7 has to
t1.resolver_name c1,
t1.resolution_id c2,
t1.short_description c3,
t1.resolution_status c4,
t1.date_created c5
from
solutions_1 t1,
tickets_1 t2
where
t2.ticket_id is null and
t2.resolution_id(+)=t1.resolution_id
order by
2 asc;
ORA-03113: end-of-file on communication channel
How can I find out where it is failing??
Any response appreciated.
Thanks,
Ken Received on Fri Jun 02 1995 - 00:00:00 CEST