Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Workaround for > 1000 columns?
In article <8i3c1a$hej$1_at_nnrp1.deja.com>,
carlona_at_georgetown.edu wrote:
> Hey, guys. I seem to have a problem.
>
> Oracle has decided that I don't need a table with more than 1000
> columns, and rather than give me enough rope to hang my database and
the
> computer it runs on, it won't let me create one. I feel I have just
> such a need, however, and splitting it into two tables would be a
major
> hassle, especially from a user's perspective (having >1000 variables
is
> bad enough without having to look for which table the right variable
is
> in).
>
> Does anyone know about a workaround for this? I can't create views
with
> > 1000 columns either, but are there any other view-like
items/options?
> This lousy rule (a round number like 1000 -- as opposed to something
> like 1024 -- has to be arbitrary) might throw another complication
into
> our project, which I dislike.
>
> Thanks a lot!
>
> Andrew Carlon
>
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