You can create a partitioned CONTEXT
index on a partitioned text table. The table must be partitioned by range. Hash, composite, and list partitions are not supported.
You might create a partitioned text table to partition your data by date. For example, if your application maintains a large library of dated news articles, you can partition your information by month or year. Partitioning simplifies the manageability of large databases, because querying, DML, and backup and recovery can act on a single partition.
On local CONTEXT
indexes with multiple table sets, Oracle Text supports the number of partitions supported by Oracle Database.
The number of partitions supported in Oracle Text is approximately 1024K-1. This limit, which should be more than adequate, is not applicable to a CONTEXT
index on partitioned tables.
Oracle Database Concepts for more information about partitioning
To query a partitioned table, you use CONTAINS
in the WHERE
clause of a SELECT
statement as you query a regular table. You can query the entire table or a single partition. However, if you are using the ORDER
BY
SCORE
clause, Oracle recommends that you query single partitions unless you include a range predicate that limits the query to a single partition.