ORA-07445: exception encountered: core dump [evaopn2()+128] [SIGSEGV] [Address not mapped to object]
Hi,
i am using 10.2.0.4.0 on unix and updating a table using
UPDATE STG_SUBSCRIBER_DETAILS SSD SET SERVICE_STATUS = 'ND' WHERE EXISTS (SELECT 1 FROM (SELECT * FROM (SELECT /*+ full(s) */ ROW_NUMBER() OVER(PARTITION BY MSISDN ORDER BY ACCT_EFFECTIVE_DT DESC, SERVICE_EFFECTIVE_DT DESC) RN, S.* FROM STG_SUBSCRIBER_DETAILS S WHERE SERVICE_STATUS <> 'ND' AND TRUNC(SYSDATE) BETWEEN TMP_ACCT_EFFECTIVE_DT AND NVL((ACCT_EFFECTIVE_END_DT), TRUNC(SYSDATE)) AND TRUNC(SYSDATE) BETWEEN NVL(TMP_PRICE_PLAN_START_DT, TRUNC(SYSDATE - 1)) AND NVL((PRICE_PLAN_END_DT), TRUNC(SYSDATE)) AND TRUNC(SYSDATE) BETWEEN NVL(TMP_SERVICE_EFFECTIVE_DT, TRUNC(SYSDATE - 1)) AND NVL((SERVICE_EFFECTIVE_END_DT), TRUNC(SYSDATE))) WHERE RN > 1) WHERE SUB_SEQ_ID = SSD.SUB_SEQ_ID)
i am using 10.2.0.4.0 on unix and updating a table using
UPDATE STG_SUBSCRIBER_DETAILS SSD SET SERVICE_STATUS = 'ND' WHERE EXISTS (SELECT 1 FROM (SELECT * FROM (SELECT /*+ full(s) */ ROW_NUMBER() OVER(PARTITION BY MSISDN ORDER BY ACCT_EFFECTIVE_DT DESC, SERVICE_EFFECTIVE_DT DESC) RN, S.* FROM STG_SUBSCRIBER_DETAILS S WHERE SERVICE_STATUS <> 'ND' AND TRUNC(SYSDATE) BETWEEN TMP_ACCT_EFFECTIVE_DT AND NVL((ACCT_EFFECTIVE_END_DT), TRUNC(SYSDATE)) AND TRUNC(SYSDATE) BETWEEN NVL(TMP_PRICE_PLAN_START_DT, TRUNC(SYSDATE - 1)) AND NVL((PRICE_PLAN_END_DT), TRUNC(SYSDATE)) AND TRUNC(SYSDATE) BETWEEN NVL(TMP_SERVICE_EFFECTIVE_DT, TRUNC(SYSDATE - 1)) AND NVL((SERVICE_EFFECTIVE_END_DT), TRUNC(SYSDATE))) WHERE RN > 1) WHERE SUB_SEQ_ID = SSD.SUB_SEQ_ID)
0