p_manage_32 /Z0102_ID1: unable to extend temp segment by 128 in tablespace TEMP
- Article Type: General
- Product: Aleph
- Product Version: 20
Description:
p_manage_32 fails. The $alephe_scratch log has:
Sat Dec 23 03:36:05 EST 2006 Error : Only 1 indexes out of 2 for table z0102 were created
Sat Dec 23 03:36:05 EST 2006 Error : Please check logs /exlibris/aleph/u17_1/abc01/scratch/create_ora_tables_z0102_id*.log
And the $data_scratch/create_ora_tables_z0102_id1.log has this error:
SQL-ALEPH_ADMIN> CREATE INDEX ABC01.Z0102_ID1 ON ABC01
.Z0102 (Z0102_REC_KEY_1 ASC)
*
ERROR at line 1:
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
Resolution:
As described in KB 5120, the z0102_id1 Oracle index has an unusually large TEMP space requirement. We see (in util a/17/11/2 for z0102) that the ABC01 z0102 is occupying 22 gig. This would indicate the need for a TEMP space of 20 gig. But it's our feeling that the recommendations in util h/1/10 for what should be included in the z0102 are too high. I recommend changing 20 bases which are more than 10% of the total database from "Y" to "N" in tab_base.eng, column 8.
manage-32 could be rerun, but normally doing util a/17/2 to build the z0102_id1 will suffice.
Note: I have also added three 2G datafiles to TEMP, raising it from 10G to 16G.
Additional Information
manage-32, z0102_id
- Article last edited: 11/27/2014