MSCPDC - ODS Load Fails ORA-01658: Unable To Create Initial Extent For Segment
(Doc ID 377391.1)
Last updated on DECEMBER 19, 2023
Applies to:
Oracle Advanced Supply Chain Planning - Version 11.5.10 to 11.5.10.2 [Release 11.5]Information in this document applies to any platform.
EXECUTABLE:MSCPDC - Planning ODS Load
EXECUTABLE:MSCPDCW - Planning ODS Load Worker
Symptoms
ODS errors with the following:
Linking of Sales Order line in MDS to its Parent Sales orders is successful.....
Index Dropping on Temp Tables successful.
<>
<>CREATE INDEX SUPPLIES_N4_IDX ON
SUPPLIES_IDX(PLAN_ID,SR_INSTANCE_ID,ORGANIZATION_ID,APPLIED,STATUS,UPDATED) PARALLEL TABLESPACE
APPS_TS_TX_IDX STORAGE( INITIAL 131072 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE
0) PCTFREE 10 INITRANS 11 MAXTRANS 255
ORA-12801: error signaled in parallel query server P000
ORA-01658: unable to create INITIAL extent for segment in tablespace APPS_TS_TX_IDX
<>
<>ALTER TABLE MSC_SUPPLIES EXCHANGE PARTITION SUPPLIES__1 WITH TABLE SUPPLIES_IDX INCLUDING
INDEXES
ORA-14098: index mismatch for tables in ALTER TABLE EXCHANGE PARTITION
Calling Linking of Sales Order for 11i source ...
Procedure LINK_SUPP_SO_DEMAND_EXT started
Index Dropping on Temp Tables successful.
<>
<>CREATE INDEX SUPPLIES_N4_IDX ON
SUPPLIES_IDX(PLAN_ID,SR_INSTANCE_ID,ORGANIZATION_ID,APPLIED,STATUS,UPDATED) PARALLEL TABLESPACE
APPS_TS_TX_IDX STORAGE( INITIAL 131072 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE
0) PCTFREE 10 INITRANS 11 MAXTRANS 255
ORA-12801: error signaled in parallel query server P000
ORA-01658: unable to create INITIAL extent for segment in tablespace APPS_TS_TX_IDX
<>
<>ALTER TABLE MSC_SUPPLIES EXCHANGE PARTITION SUPPLIES__1 WITH TABLE SUPPLIES_IDX INCLUDING
INDEXES
ORA-14098: index mismatch for tables in ALTER TABLE EXCHANGE PARTITION
Calling Linking of Sales Order for 11i source ...
Procedure LINK_SUPP_SO_DEMAND_EXT started
STEPS
Run standard data collections
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |