Archive - Specify Oracle Content Indexing Columns

Archive - Specify Oracle Content Indexing Columns

Specify the columns that will be indexed. Indexes are automatically recalculated when rows are archived or restored.  When set, search and query the archived database stored on the media without restoring the data.

Table Name

The table the query is performed against. By default this is populated with the selected Archiving Table.

Columns Available

All the columns that are currently not part of the selected table's content indexing. Select one or more columns to add them to the table's content index.

Columns to Index

All the columns that are part of the table's content index. Select one or more columns to remove them from the table's content index.

Add >

Add the selected columns to the table's content index.

< Remove

Remove the selected columns from the table's content index.

Add >>

Add all table columns to the table's content index.

<< Remove

Remove all columns from the table's content index.

Table/Columns to Index

The complete list of the tables and columns that have a content index relationship.  This is updated as columns are added or removed.