it means total length of column sizes in group/order by cannot exceed your block size.
Raj
--------------------------------------------------------------------------------
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !
-----Original Message-----
From: Murali_Pavuloori/[EMAIL PROTECTED]
[mailto:Murali_Pavuloori/[EMAIL PROTECTED]]
Sent: Tuesday, September 16, 2003 1:30 PM
To: Multiple recipients of list ORACLE-L
Subject: restriction on the number of columns in select statement.
Can someone tell me the restriction on the # of columns in the select
clause of the statement.. We are running into sort key too long -
ORA-01467. I am told there is no order by or group by in the query. I need
to look @ the query to make sure there are no references in the statement
that generates a implicit sort. I tried to search on the restriction and
could not comeup with anything.
Thanks for your help
Murali.
********************************************************************This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*********************************************************************2
