Re: Too many joins? ORA-01792: maximum number of columns in a table or view is 1000

Home -> Community -> Usenet -> c.d.o.misc -> Re: Too many joins? ORA-01792: maximum number of columns in a table or view is 1000

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Tue, 06 Apr 2004 07:50:24 -0700
Message-ID: <1081263005.974550@yasure>

Kurta wrote:
> 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.

Does that mean it can't be fixed?

If not ... get a large roll of duct tape.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Tue Apr 06 2004 - 09:50:24 CDT