Environment: Oracle 220.127.116.11 running on HP-UX Itanium RX8640 with 16 CPUs and OS B.11.31
I would like to create a Text index on a clob column from a table that has 27 partitions. Some partitions are much larger than others (some have as many as 88,000,000 rows while others have as few as 3,000,000) and I am only interested in indexing 8 of the 27 partitions. I do not wish to index the others. Is this possible?