Primary Key: Maximun number columns exceeded?

From: Kelly <kgrigg_at_acxiom.com>
Date: 1997/07/31
Message-ID: <5rqn01$398_002@conway.acxiom.com>#1/1

Hello All!

I am using a script to try to build a Primary Key constraint, and I got an error of:

ORA-02257 Max # of columns exceeded.

How do I raise the number of columns? This is on a join table looked at by a number of tables generated from a supertype/subtype entity relationship. I need to have all the possible key columns, don't I? The Reference said to remedy this I had to reduce the number of columns...but I think I need them. I am working with Personal Oracle 7. My Primary constraint script for this table look like this:

PROMPT Adding PRIMARY Constraint To ADDRESS_ASSOCIATIONS Table

ALTER TABLE ADDRESS_ASSOCIATIONS ADD (

      CONSTRAINT ADD_ASSOC_PK
      PRIMARY KEY (ADDRESS_ADDRESS_ID,
                   BUSINESS_LISTING_NUMBER,
                   BUSINESS_SECTION_NUMBER,
                   BUSINESS_PAGE_NUMBER,
                   BUSINESS_BOOK_BOOK_NUMBER,
                   BUSINESS_BOOK_PUB_DATE,
                   CHILD_LISTING_NUMBER,
                   CHILD_SECTION_NUMBER,
                   CHILD_PAGE_NUMBER,
                   CHILD_BOOK_BOOK_NUMBER,
                   CHILD_BOOK_PUB_DATE,
                   DESC_BOOK_BOOK_NUMBER,
                   DESC_BOOK_PUB_DATE,
                   DESC_LISTING_NUMBER,
                   DESC_SECTION_NUMBER,
                   DESC_PAGE_NUMBER,
                   GOV_LISTING_NUMBER,
                   GOV_SECTION_NUMBER,
                   GOV_PAGE_NUMBER,
                   GOV_BOOK_BOOK_NUMBER,
                   GOV_BOOK_PUB_DATE,
                   INDIVIDUAL_BOOK_BOOK_NUMBER,
                   INDIVIDUAL_BOOK_PUB_DATE,
                   INDIVIDUAL_LISTING_NUMBER,
                   INDIVIDUAL_SECTION_NUMBER,
                   INDIVIDUAL_PAGE_NUMBER,
                   OTHER_BOOK_BOOK_NUMBER,
                   OTHER_BOOK_PUB_DATE,
                   OTHER_LISTING_NUMBER,
                   OTHER_SECTION_NUMBER,
                   OTHER_PAGE_NUMBER,
                   INDIVIDUAL_INDIVIDUAL_TYPE)

USING INDEX
PCTFREE 10)
/
Can anyone offer some suggestions? What is the limit and can I raise it? If so, how?

TIA!! Kelly
kgrigg_at_acxiom.com

ps. Please CC by mail too..our newsfeed still isn't reliable.

"If you've had half as much fun as me...

    ....Then I've had twice as much fun as you!!"

kgrigg_at_acxiom.com
cayenne_at_cei.net

Visit my Website at: http://www.cei.net/~cayenne/index.html Received on Thu Jul 31 1997 - 00:00:00 CDT