Re: maximum row size
Steve Williams wrote:
> Is there any way to get rid of the limitation to
> where you can only have a "maximum number of
> attributes per key (ie. per table) as 32?"
I can't tell whether you are right or I'm right; I read that part differently, I don't read "per key" as meaning "per table". I haven't tried putting more than some 25 fields (columns, attributes) in a table, but I would expect it to work with more than 32. Go ahead and try.
I understand the limitation this way: whenever my table has a key, at most 32 of the fields can be part of the key. In our case it's not a problem. Even though many modern databases have only one field in the key (typically an ID or OID), we still use primary keys combined from 2 or 3 fields. That still leaves us a lot of room within the 32 fields limitation.
I hope my reply doesn't come too late - I realize you asked 3 months ago.
Yours, Ole
Subject
Views
Written By
Posted
11434
July 07, 2005 10:17PM
4703
July 08, 2005 02:01PM
4053
June 29, 2006 04:48AM
3641
March 29, 2006 03:31PM
Re: maximum row size
3050
June 29, 2006 05:00AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.