PK 3036062 Oracle Error 1632 is given in the wms_alert.log

Resolving The Problem

To troubleshoot this issue do the following:
1. From the error log, identify the package and the oracle error. In this case the package is PK3036062 and the error is 1632.
2. At the unix prompt by running "oerr ora 1632" , the error is described as follows:
oerr ora 1632
01632, 00000, "max # extents (%s) reached in index %s.%s"
// *Cause: An index tried to extend past maxextents
// *Action: If maxextents is less than the system max, raise it. Otherwise,
// you must recreate with larger initial, next or pctincrease params.

3. Then run "tabname 3036062" at the unix prompt. This will show the table on which the error is occuring. For this case it is:
T074303 CARTON_HDR
4. Then open sqlplus and do the following query keeping in mind that these queries are examples and have to be altered according to your specific needs:

select substr(segment_name,1,20), substr(tablespace_name,1,10), count(*) from dba_extents where segment_name like '%074303' group by tablespace_name, segment_name

The above query gives all the segments from dba_extents and what the count(extents) is:

SUBSTR(SEGMENT_NAME, SUBSTR(TAB COUNT(*)
-------------------- ---------- ----------
T074303 T56 54
X0743031 T56X 205
X07430310 T56X 174
X0743032 T56X 126
X0743033 T56X 187
X0743034 T56X 197
X0743035 T56X 163
X0743036 T56X 162
X0743037 T56X 242
X0743038 T56X 249
X0743039 T56X 143

select substr(index_name,1,30), max_extents from all_indexes where index_name like '%074303%'

X0743031 2147483645
X07430310 249
X0743039 249
X0743038 249
X0743037 249
X0743036 249
X0743035 249
X0743034 249
X0743033 249
X0743032 249

From the above two queries, you can see that X0743037 and X0743038 have reached 249 which is the max extents for these indexes. So in these cases, send the DBA the query output and ask him to increase the extents for the indexes. Note that you have to modify the queries in order to give the table name which is causing you trouble to complete your investigation.