Parallel indexing - Cannot see the new index in either the client of web opac
- Article Type: General
- Product: Aleph
- Product Version: 17.01
Description:
I've run thorugh the parallel indexing document a number of times and run p_manage_01. If I look at the files directly in Oracle, there are lots of entries so it seems that the parallel indexing job ran fine. However, I cannot use the library in either the client or web-opac to run word searches. In the client I get zero results, in the opac it just hangs. Apparently I have missed something but I'm stuck. I have not tried to apply the new index yet, I wanted to make sure that I could check things in the opac first.
Resolution:
I find that the abc21 z98_id does not exist:
Enter Table Name : z98
Defined in file_list:
__________________________________________________________
IND z98_id 128M 0K TS3X
__________________________________________________________
Exist in the Database:
Enter CR to continue...
When I tried to build the z98_id using util a/17/2, I got this:
CREATE UNIQUE INDEX ABC21.Z98_ID ON ABC21.Z98 (Z98_REC_KEY ASC)
*
ERROR at line 1:
ORA-01652: unable to extend temp segment by 512 in tablespace TS3X
util o/14/1 shows this:
TABLESPACE_NAME TOTAL_FREE_SPACE MAX_EXTENT NUM_FREE_EXTENTS
------------------------------ ---------------- ---------- ----------------
TS3X 284.156092 112.061557 3
And util a/17/10/2 shows this:
IND z98_id 128M 0K TS3X
The largest available extent in the TS3X tablespace is 112M and the z98_id is looking for 128M.
You need to add another datafile to the TS3X tablespace -- and then run util a/17/2 for z98_id.
Additional Information
jojo
- Article last edited: 10/8/2013