Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: /*+ ORDERED LEADING() */ Destroys session.
I seem to have the same problem, so perhaps it is a bug as JL
suggested.
Red Hat Linux release 6.1 (Cartman)
Kernel 2.2.12-20 on an i586
login: oracle
Password:
Last login: Sat Dec 15 23:34:23 from hpwin.buck.com
[~] $sqlplus
SQL*Plus: Release 8.1.6.0.0 - Production on Sun Dec 16 22:51:24 2001
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Enter user-name: scott
Enter password:
Connected to:
Oracle8i Enterprise Edition Release 8.1.6.1.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
SQL> SELECT /*+ ORDERED LEADING(Dual) */ * FROM Dual;
SELECT /*+ ORDERED LEADING(Dual) */ * FROM Dual
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
SQL> Received on Sun Dec 23 2001 - 12:32:13 CST