Select to view content in your preferred language

Max number of columns in UN table?

1319
3
06-15-2021 03:10 PM
forestknutsen1
MVP Regular Contributor

What is the maximum number of columns one can have in a UN feature class? We are on Oracle 19. For this database, the maximum is 1000. Am I right in thinking this will be our cut-off?

0 Kudos
3 Replies
AnthonyRyanEQL
Frequent Contributor

Are you really thinking of implementing something with that many columns? I'm really interested in your use case for this. Thanks

0 Kudos
forestknutsen1
MVP Regular Contributor

No, we have about 700 columns in our electric network point features. But there are only about 200 unique columns. Also, there are some legacy, aka garbage, columns in there. So, we may be able to get it down to sub 200. I am just wondering what the upper limit of the model is. 

0 Kudos
forestknutsen1
MVP Regular Contributor

Bumping this one up... I know someone at Esri knows this off the top of their head 🙂

0 Kudos