Error for z101_id opening new library: "Such column list already indexed"

• Article Type: General
• Product: Aleph
• Product Version: 16.02

Description:
I need to know if this ORA error that appeared in the LOG when I opened up a new library is an issue?

Elapsed: 00:00:00.01
15:29:55 SQL-ALEPH_ADMIN> CREATE UNIQUE INDEX ODN07.Z101_ID ON ABC07.Z101 (Z101_REC_KEY ASC)
*
ERROR at line 1:
ORA-01408: such column list already indexed

Resolution:
I find that when I do util a/17/4 for the z101_id it says that it is not managed by abc07, but when I try util a/17/2 to create the z101_id, I get the "Such column list already indexed" message which you describe.

But doing util a/17/14 for abc07, I find the following:

Enter Table Name : z101

Defined in file_list:
__________________________________________________________
IND z101_id 128M 0K TS3X
__________________________________________________________

Exist in the Database:

INDEX_NAME STATUS INDEX_TYPE UNIQUENESS COLUMN_NAME
--------------- ------- ---------- ----------- --------------------
IOT_Z101 VALID IOT - TOP UNIQUE Z101_REC_KEY

Note that the name of the index is not "Z101_ID" but rather "IOT_Z101". This has to do with the fact that the $alephm_root/sql_tab/z101_create.sql on your server contains the following line:

CONSTRAINT IOT_Z101 PRIMARY KEY

(This site seems to be the only one with this line in z101_create.sql.)

• Article last edited: 10/8/2013