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

    Creating z00r tables for authorities: "invalid STORAGE option"

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

    Description:
    We would like to create z00r tables for our authority libraries abc10 and abc11, for statistical purposes.

    Following KB Item 5870, we see that the steps to follow are:

    1 - add appropriate lines for z00r to the abc10 and abc11 file_list;
    2 - run util a/17/1 to create the Oracle tables and indexes;
    3 - set CREATE-Z00R to Y in abc10 and abc11 tab100;
    4 - run p_manage_07 for 'Update only Z00R' in each library.

    We run into a problem at step 1.

    Lines for z00r and its indexes exist in /exlibris/aleph/a20_2/aleph/tab/file_list.BIB:

    TAB z00r 100K,128K,4M,128M,128K,128K 0K ts0,TS1D,TS2D,TS3D,TS1D,TS1D
    IND z00r_id 100K,128K,4M,4M,128K,128K 0K ts1,TS1X,TS2X,TS2X,TS1X,TS1X
    IND z00r_id1 100K,128K,4M,4M,128K,128K 0K ts1,TS1X,TS2X,TS2X,TS1X,TS1X

    If we add those lines to .../abc10/file_list, we get this error when we try to run util a/17/1:

    *********************************
    Enter value for 4: STORAGE (INITIAL 100K,128K,4M,1280K128K,128K NEXT ts0,TS1D,TS2D,TS3D,TS1D,TS1D MINEXTENTS 1 PCTINCREASE 0)
    *
    ERROR at line 8:
    ORA-02143: invalid STORAGE option

    ...

    aleph_admin@ALEPH20> 11:25:48 aleph_admin@ALEPH20> Enter value for 4: STORAGE (INITIAL 100K,128K,4M,4M,0K8K,128K NEXT ts1,TS1X,TS2X,TS2X,TS1X,TS1X MINEXTENTS 1 PCTINCREASE 0)
    *
    ERROR at line 2:
    ORA-02143: invalid STORAGE option
    **********************************

    How can we properly configure the file_list to make util a/17/1 work?

    Resolution:
    You cannot copy a line from an ./aleph/tab/file_list.xxx to a $data_root file_list (such as, ./abc10/file_list). It's *not* in the proper format.

    You have two choices:

    1. copy the lines from ./aleph/tab/file_list.BIB to ./aleph/tab/file_list.AUT ; or

    2. insert file_list entries in the proper form into the ./abc10/file_list, such as:

    TAB z00r 128K 0K TS1D
    IND z00r_id 128K 0K TS1X
    IND z00r_id1 128K 0K TS1X


    • Article last edited: 10/8/2013