Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    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