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