Oracle Text Search

About Oracle Text Search

The Oracle Text Search capabilities enable you to query documents stored in the database in text properties or columns, and in common formats, such as:

  • Word

  • Excel

  • PowerPoint

  • WordPerfect

  • HTML

  • pdf

The Oracle Search capabilities combine the text information with regular database information. The Text Search feature indexes the text content to deliver fast, accurate, flexible analysis, and retrieval of information. The features include:

  • Powerful Full. This allows you to perform a variety of text-data searches including boolean, exact phrase, proximity, section searching, misspellings, stemming, wildcard, thesaurus word equivalence, and scoring.

  • Theme Search. This compliments full-text search and allows you to search for documents by their them-ConText, as well as text content.

  • ANSI Standard SQL Support. This makes text queries straightforward from any tool or environment that supports SQL or PL/SQL.

  • Mixed Search. This allows a single SQL query to search for document text, themes, and information in regular database columns.

To use Oracle Text Search, you must:

  1. Satisfy the system requirements for installing Oracle.

  2. Install Oracle.

  3. Install CES Database Server 9.1.9 Release.

  4. Create a new Oracle database, and load seed data.

    OR

    Migrate your pre-Oracle10g database to Oracle10g using the migration tools. Update your CES Database to the 9.1.9 level.

  5. Install the Text Search option in the new Oracle database.

  6. Create language specific preferences for your language using the option Language-Specific Preferences for Text, if your language is non-American.

  7. Create Text (domain) index using EDM 9.1.9.