Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Too many joins? ORA-01792: maximum number of columns in a table or view is 1000
Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl> wrote in message news:<8j3370pd1129jph976avkn01ied2s880p7_at_4ax.com>...
> On 5 Apr 2004 09:04:38 -0700, submit_at_galleus.com (Kurta) wrote:
>
> >
> >I assume that the sum of the column count of all tables included in
> >the query exceeds the 1000 limit. But, is there a way to workaround
> >this problem?
>
> Sure, normalize your datamodel
Thanks, it's not my datamodel.
K. Received on Tue Apr 06 2004 - 02:31:36 CDT