Applying Table In Siebel Tools Does Not Create Index If Column Length Exceeds 450 Characters (Doc ID 2673109.1)

Last updated on SEPTEMBER 27, 2021

Applies to:

Symptoms

Applying table in Siebel Tools does not create an index if column length exceeds 450 characters.

The issue can be reproduced at will with the following steps:
1) Select any table in Siebel Tools, e.g. S_EVT_ACT
2) Create new column X_TEST with type varchar and length 512
3) Create new index X_TEST_INDEX on this new column
4) Apply table
5) Check database whether new index X_TEST_INDEX was created

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.