The Add/Remove Index Column icons of the Open Index Details tab are disabled. (4226116)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

The Add/Remove Index Column icons of the Open Index Details tab are disabled.
Description

The Add/Remove Index Column icons of the Open Index Details tab are disabled. However, fields under Storage tab are enabled and modifiable. How to modify columns on an existing Index?
Cause

Columns cannot be modified on an existing index in Oracle. Only certain parameters are modifiable on an existing index.
Resolution

To modify columns of an existing index, drop index and recreate the index with the new column list.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title