Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: limit on number of tables in join

RE: limit on number of tables in join

From: Brian Mullin <bmullin_at_salesforce.com>
Date: Fri, 29 Apr 2005 09:55:28 -0700
Message-ID: <6A7AA073C12C0F41B56DD7B9A16F44B90218E9AF@ex-2.internal.salesforce.com>


I've run across an unusual bug (4204878/ 3765373/ 3004824) on Oracle 9.2.0.5. When more than 22 ANSII joins are done in a select statement, an ORA-01445 occurs. According to Support:

"1- One solution is to rewrite the query to not use ANSI joins.=20 2- Rewrite the join queries with fewer exposed columns, either by declaring named views with only relevant columns, or by using inlined subqueries with only relevant columns."

Of course, if you use less than 22 ANSII joins, the bug does not manifest.

-Brian

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Apr 29 2005 - 12:59:49 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US