util a/17/2 (create Oracle index): "ORA-01408: such column list already indexed"
- Article Type: General
- Product: Aleph
- Product Version: 18.01
Description:
util a/17/14 for abc01 shows that the Oracle indexes for the abc01 z970 do not exist:
Enter Table Name : z970
Defined in file_list:
__________________________________________________________
IND z970_id 4M 0K TS2X
IND z970_id1 4M 0K TS2X
__________________________________________________________
Exist in the Database:
Enter CR to continue...
I tried building them, but get this:
util a/17/2 for z970 :
aleph_admin@ALEPH0> 22:45:31 aleph_admin@ALEPH0> CREATE INDEX ABC01.Z970_ID ON ABC01.Z970 (Z970_REC_KEY ASC)
*
ERROR at line 1:
ORA-01408: such column list already indexed
Resolution:
This message is appearing because the z970 table is LS-ed to the ABC03 parallel index library in the ABC01 file_list:
LS Z970 ABC03
Though the entries for z970_id and z970_id1 in the ABC01 file_list are commented out, the $aleph_root/tab/file_list.BIB has these entries:
IND z970_id 100K,128K,128K,128K,128K,4M 0K ts1,TS1X,TS1X,TS1X,TS1X,TS2X
IND z970_id1 100K,128K,128K,128K,128K,4M 0K ts1,TS1X,TS1X,TS1X,TS1X,TS2X
(This is where util a/17/14 is getting the "Defined in file_list" entries.)
It seems that when you do util a/17/2 it is finding the existing z970_id and z970_id1 indexes in ABC03, but when you are doing util a/17/14, it does not find them....
What's odd about this is that at most sites, an "LS Z970 ABC03" will result in a message
Table/Index z970 not managed by ABC01 check file list
when you do util a/17/14....
- Article last edited: 10/8/2013