Re: bug (#1070 - Too many key parts specified)
Posted by: Bill Karwin
Date: July 17, 2006 10:00AM

As far as I know, a fulltext index can have only 16 columns per index.

That's 1 greater than other types of indexes! They are limited to 15 columns per index.

I would suggest that you create two fulltext indexes, but that won't work because IIRC there can be only one fulltext index per table. You could put the other 9 columns in a second table that is linked one-to-one with your main table.

Options: ReplyQuote




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.