RE: limit on number of tables in join
- From: "Brian Mullin" <bmullin@xxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 29 Apr 2005 09:55:28 -0700
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
