Re: Workaround for > 1000 columns?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: 2000/06/12
Message-ID: <960845631.20056.0.nnrp-14.9e984b29@news.demon.co.uk>#1/1

Using TYPES won't work. The 'leaf-attributes' of the types contribute to the column count of the parent table.

I agree with previous posters though, that getting to 1,000 columns is not a good
idea anyway.

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Mark D Powell wrote in message <8i3ga1$kfb$1_at_nnrp1.deja.com>...


>In article <8i3c1a$hej$1_at_nnrp1.deja.com>,

>

>If you have the standard edition of Oracle then I think you are out of

>luck.  If you have the Enterprise Edition with the Object Option then

>perhaps you could organize the data into types and then build the table

>definition using types.  I have not tried this but I believe it would

>work, but it isn't the way I would want to handle this.  I would rather

>have multiple tables.  Debugging SQL syntax errors can get more

>difficult as the number of columns grows.

>

>--

>Mark D. Powell  -- The only advice that counts is the advice that

> you follow so follow your own advice --

>

>

>Sent via Deja.com http://www.deja.com/

>Before you buy.

Received on Mon Jun 12 2000 - 00:00:00 CDT