Error opening library: "such column list already indexed" for Z101_ID
- 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 on PROD is an issue?
Elapsed: 00:00:00.01
15:29:55 SQL-ALEPH_ADMIN> CREATE UNIQUE INDEX ODN07.Z101_ID ON ODN07.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 odn07, but when I try util a/17/2 to create the z101_id, I get the such column list already indexed which you describe.
But doing util a/17/14 for odn07, I find that the z101_id *is* defined:
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
Since the index exists, there is no immediate problem, however this "IOT - TOP" is due to this line in the ./alephm/sql_tab/z101_create.sql:
CONSTRAINT IOT_Z101 PRIMARY KEY
This is non-standard. I restored the version of z101_create.sql which did not have this line. (This change has no effect until p_manage_27, which does a drop/create of the z101, is run.)
- Article last edited: 10/8/2013