About Oracle Text Tables |
Previous |
Next |
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 with Oracle Text.
Depending on the type of Oracle Text index, you populate rows in your text table with one of the following elements:
Text information, which can be documents or text fragments. (Supported by CONTEXT Index Type and CTXCAT Index Type.)
Path names of documents in your file system. (Supported by CONTEXT Index Type.)
URLs that specify World Wide Web documents. (Supported by CONTEXT Index Type.)
Text queries/rules. (Supported by CTXRULE Index Type).
Tables and indexes for Oracle Text query applications are described in detail in the Oracle Text documentation.
The chapter about indexing in Oracle Text Application Developer's Guide
The CREATE
INDEX
SQL statement in Oracle Text Reference