Hi,
When I am trying to insert into a table with select query. We are getting below error message.
ORA-01652: unable to extend temp segment by 64 in tablespace TEMP.
INSERT /*+APPEND*/
INTO FAC_PRODUCT
(partition_k,
PREFERE,
COUNTERPARTY_CODE,
CONTRACT_TYPE,
AMOUNT,
CURRENCY,
ATTRIBUTE_1,
FACILITY_REFERENCE)
(SELECT p_mon,
FL.FACILITY_REFERENCE AS PREFERE,
FC.COUNTERPARTY_CODE,
FP.CONTRACT_TYPE,
SUM(F.AMOUNT) AMOUNT,
F.CURRENCY CURRENCY,
F.ATTRIBUTE_1,
FL.FACILITY_REFERENCE
FROM TRIPLED F,
NJYOP FL,
BRUNEL FP,
REGISR FC
WHERE FL.TABLE_NAME = 'FACILITY'
AND F.PREFERE = FL.PREFERE
AND FL.PREFERE = FP.FACILITY_REFERENCE
AND FL.FACILITY_REFERENCE = FC.FACILITY_REFERENCE
AND F.ATTRIBUTE_1 NOT IN ('OUTER', 'MOTHER')
GROUP BY FC.COUNTERPARTY_CODE,
FP.CONTRACT_TYPE,
F.ATTRIBUTE_1,
FL.FACILITY_REFERENCE,
F.CURRENCY);
We are getting this error message only for that above inset statement alone. Remaining statements are working fine.