| ORA-0430 Error for SQL [message #65662] |
Wed, 24 November 2004 23:58 |
Milind Deshpande
Messages: 93
Registered: May 2004
|
Member |
|
|
Hi All,
I have this problem in the SQL. Whenever i run it I get ORA-0430 error.the query is like this :-
Select
TAFM.MEMBERSHIP_ID,
TAFM. LAST_MODIFIED_DATE,
TOA.MODIFIED_Z
from
CUS.TACCOUNT@DT.LINK TACCT,
CUS.TORG_AFFILIATION@DT.LINK TOA,
TAFFL_MEMBERSHIP TAFM
where
TO_DATE(TO_CHAR(TAFM. LAST_MODIFIED_DATE,'DD/MM/YYYY'),'DD/MM/YYYY') <>
TO_DATE(TO_CHAR(NVL(TOA. MODIFIED_Z, TAFM.CREATED_DATE),'DD/MM/YYYY'),'DD/MM/YYYY') AND
TACCT.ORG_ID_C = TOA.ORG_ID_C AND
TACCT.ORG_NME_SEQ_C = TOA.ORG_NME_SEQ_C AND
TACCT.ACCT_ID_C = TAFM.ENTITY_ID and
TOA.AFFLN_ID_C = TAFM.AFFL_ID AND
AFFLN_SUB_ID_C IS NULL
The Erroe that i get when i execute this query :-
'ORA-04030: out of process memory when trying to allocate 72 bytes
(callheap,qerrmbv[[]]: qerrmObnd)'
Can anybody help me on this that why this error is coming because if this is a memory error than I cant increase the memory that is the problem. SO,can in any way this query can be tuned so that it absorbs less bytes(Memory).
This is the explain plan of the query:-
SELECT STATEMENT, GOAL = FIRST_ROWS 398 1 130
NESTED LOOPS 398 1 130
NESTED LOOPS 397 1 91
TABLE ACCESS FULL ARROW TAFFL_MEMBERSHIP 395 544166 19045810
REMOTE 2 1 56
REMOTE 2 1 39
Pls. help me on this it is urgent.
Thanks in advance
Milind.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
