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