Home

Getting Started

Utilities

Indexing

Omnidex

Development

Tutorials

Quick Links

 

OMNIDEX Indexing

Index Maintenance

Periodic Updates

 

 

Index Maintenance

Installing the Indexes

After designing the index installation, use the Omnidex utility, DBINSTAL, to install the indexes onto the environment catalog. This step must be performed prior to building the indexes.

  • If this is a first time installation, you must perform this step manually, specifying the indexes that are to be installed on each column.
  • If you are reinstalling the indexes on a preexisting installation, you can use a script file to perform this task. Use OAHELPER to automatically generate this script file from the existing installation.

If the installation has changed, you may want to do the installation manually and then generate a new script file for future updates, rather than trying to modify and existing script. Any errors in the script will cause the installation to fail.

To install the indexes manually, run DBINSTAL from a system prompt and follow the screen prompts:

> dbinstal

To use an installation script, run DBINSTAL from a system prompt and pass the installation script as a command line argument:

> dbinstal < install.in

 

Periodic Updates

From time to time, it may be necessary to reinstall the indexes. For example, when upgrading Omnidex to a newer version. In this case, you will need to recompile the environment catalog and reinstall the indexes.

If upgrading Omnidex to a new "Major" version, 3.8 to 4.1 for example, or if the index installation changed, it may not be necessary to rebuild the indexes.

Top