1 Reply Latest reply on May 22, 2013 6:18 PM by Barbara Boehmer

    Can I Index Only Some Partitions from a Large Table?

    Paul V.
      Environment: Oracle 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?