Storing Text in the Text Table

For CONTEXT data storage, use these datastore types to store documents in your text table.

• DIRECT_DATASTORE: In one column

• MULTI_COLUMN_DATASTORE: In multiple columns (Oracle Text concatenates the columns into a virtual document, one document for each row.)

• DETAIL_DATASTORE: Primary-detail relationships (Store one document across a number of rows.)

• NESTED_DATASTORE: In a nested table

Oracle Text supports the indexing of the XMLType data type, which you use to store XML documents.

For CTXCAT data storage, you can store short text fragments, such as names, descriptions, and addresses, over a number of columns. A CTXCAT index improves performance for mixed queries.