Database Administration (MOSC)

MOSC Banner

ORA-07445: exception encountered: core dump [evaopn2()+128] [SIGSEGV] [Address not mapped to object]

edited Feb 4, 2010 8:25PM in Database Administration (MOSC) 2 commentsAnswered
 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)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center