Location of Text

The basic prerequisite for an Oracle Text query application is to have a populated text table. The text table is where you store information about your document collection and is required for indexing.

When you create a CONTEXT index, you can populate rows in your text table with one of the following elements:

  • Text information (can be documents or text fragments)

  • Path names of documents in your file system

  • URLs that specify Web documents

Figure 3-2 illustrates these different methods.

When creating a CTXCAT or CTXRULE index, only the first method shown is supported.

Figure 3-2 Different Ways of Storing Text

Description of
Description of "Figure 3-2 Different Ways of Storing Text"

By default, the indexing operation expects your document text to be directly loaded in your text table, which is the first method shown previously.

However, when you create a CONTEXT index, you can specify the other ways of identifying your documents such as with filenames or with URLs by using the corresponding data storage indexing preference.