SELECT DISTINCT causes ORA-03113 only on SQLPlus
From: BobG <robert.goulart_at_sagacityus.com>
Date: 6 May 2004 19:46:07 -0700
Message-ID: <acc1022c.0405061846.74bf7d7_at_posting.google.com>
Date: 6 May 2004 19:46:07 -0700
Message-ID: <acc1022c.0405061846.74bf7d7_at_posting.google.com>
- The issue This following query works fine on Toad and PowerBuilder yet when it is run on SQLPlus I get: "ORA-03113: end-of-file on communication channel"
When I remove the distinct from the first line (capitalized below) it runs fine on SQLPlus.
Is there some flag I need to set in SQLPlus to get this to work properly?
- The query in question: SELECT DISTINCT t2.USER_GROUP_ID nn FROM scott.T_XR_CUST t2 ,(SELECT distinct t2.USER_ID FROM scott.T_XR_CUST_ORDER t2 WHERE rownum <= 27526) t8 WHERE t2.USER_ID = t8.USER_ID ;
- The tables I am selecting from create table scott.t_xr_cust (cust_id number(10,0) NOT NULL, ,user_group_id number(10,0) NOT NULL ); Primary key is cust_id.
create table scott.t_xr_cust_order
(cust_id number(10,0) NOT NULL,
,order_id number(10,0) NOT NULL
);
Primary key is cust_id, order_id.
Foreign key constraint exists on the cust_id column and tr_xr_cust.cust_id.
- Environment OS: Running Windows XP (Home Edition) on a Toshiba A25-S207 laptop.
SQL*Plus: Release 9.2.0.1.0 - Production
Personal Oracle9i Release 9.2.0.1.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production Received on Fri May 07 2004 - 04:46:07 CEST