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:
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
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.