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

    ORA-02219: invalid NEXT storage option value

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

    Description:
    rep_change #000912 says:

    4. Add the following two lines to ./[xxx_library]/file_list where xxx is the
    each library type that already has z13 ( BIB, ADM, HOL, ILL..)
    TAB z13u 400K,128K,4M,4M,128M,960M 0K ts0,TS1D,TS2D,TS2D,TS3D,TS4D
    IND z13u_id 100K,128K,4M,4M,4M,128M 0K ts1,TS1X,TS2X,TS2X,TS2X,TS3X

    5. Use UTIL-A-17-1 in each library z13 is used (BIB, ADM, HOL, ILL..)to create z13u table and its index.

    So I have added these lines to the abc01file_list:

    TAB z13u 50M 0K TS2D
    IND z13u_id 50M OK TS2X


    When I ran step 5 on abc01 I got an error:

    SQL-ALEPH_ADMIN> 16:16:31 SQL-ALEPH_ADMIN> STORAGE (INITIAL 50M NEXT OK MINEXTENTS 1 PCTINCREASE 0)
    *
    ERROR at line 2:
    ORA-02219: invalid NEXT storage option value

    Resolution:
    Rather than being "0K" (zero-K) , the IND line has "OK" (letter O - K). It needs to be "0K".


    • Article last edited: 10/8/2013