Hi,
Whenever we try to run the following query we got ora-00600 error:
What can be the possible Cause??????
We found out that the following lines from end of query are creating the
problem
if we use only one condition out of these two the query works......
AND (anccorpfilter.id_ancestor IN (137,193,219)
OR (anccorpfilter.id_ancestor = 1 and anccorpfilter.num_generations =
1)))
Thanks
--Harvinder
EXTRACT FROM THE USER TRACE FILE
-------------------------------------------------------------
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [sorsik_2], [], [], [], [], [],
[], []
Current SQL statement for this session:
SELECT
accstate.status "AccountStatus",
accstate.vt_end "AccountStatus_EndDate",
accstate.vt_start "AccountStatus_StartDate",
acc.acc_type "AccountType",
t_av_contact.c_address1 "address1",
t_av_contact.c_address2 "address2",
t_av_contact.c_address3 "address3",
ancparentmap.nm_login "AncestorAccount",
ancparent.id_ancestor "AncestorAccountID",
ancparentmap.nm_space "AncestorAccountNS",
t_av_internal.c_billable "billable",
t_av_contact.c_city "city",
t_av_contact.c_company "company",
t_av_contact.c_contacttype "contacttype",
t_av_contact.c_country "country",
t_av_internal.c_currency "currency",
uc.day_of_month "DayOfMonth",
uc.day_of_week "DayOfWeek",
t_av_contact.c_email "email",
t_av_contact.c_facsimiletelephonenumber "facsimiletelephonenumber",
uc.first_day_of_month "FirstDayOfMonth",
t_av_contact.c_firstname "firstname",
t_av_internal.c_folder "folder",
ancparent.b_children "HasChildren",
ancparent.vt_end "Hierarchy_EndDate",
ancparent.vt_start "Hierarchy_StartDate",
t_av_internal.c_invoicemethod "InvoiceMethod",
t_av_internal.c_language "Language",
t_av_contact.c_lastname "lastname",
t_av_contact.c_middleinitial "middleinitial",
accmap.nm_space "name_space",
accprmap.nm_login "PayerAccount",
accprmap.nm_space "PayerAccountNS",
accpr.id_payer "PayerID",
t_av_internal.c_paymentmethod "PaymentMethod",
accpr.vt_end "Payment_EndDate",
accpr.vt_start "Payment_StartDate",
t_av_contact.c_phonenumber "phonenumber",
t_av_internal.c_pricelist "pricelist",
uc.second_day_of_month "SecondDayOfMonth",
t_av_internal.c_securityanswer "SecurityAnswer",
t_av_internal.c_securityquestion "SecurityQuestion",
uc.start_day "StartDay",
uc.start_month "StartMonth",
uc.start_year "StartYear",
t_av_contact.c_state "state",
t_av_internal.c_statusreason "StatusReason",
t_av_internal.c_statusreasonother "StatusReasonOther",
t_av_internal.c_taxexempt "taxexempt",
t_av_internal.c_taxexemptid "TaxExemptID",
t_av_internal.c_timezoneid "timezoneid",
t_av_internal.c_usagecycletype "usagecycletype",
accmap.nm_login "username",
t_av_contact.c_zip "zip",
acc.id_acc "_AccountID"
FROM
t_account acc
INNER JOIN t_account_mapper accmap
ON accmap.id_acc = acc.id_acc
INNER JOIN t_payment_redirection accpr
ON accpr.id_payee = acc.id_acc
AND '15-mar-2002'BETWEEN accpr.vt_start AND accpr.vt_end
INNER JOIN t_account_mapper accprmap
ON accprmap.id_acc = accpr.id_payer and accprmap.nm_space =
accmap.nm_space
INNER JOIN t_account_state accstate
ON accstate.id_acc = acc.id_acc
AND '15-mar-2002'BETWEEN accstate.vt_start AND accstate.vt_end
INNER JOIN t_acc_usage_cycle accuc
ON accuc.id_acc = acc.id_acc
LEFT OUTER JOIN t_account_ancestor ancparent
ON ancparent.id_descendent = acc.id_acc and ancparent.num_generations =
1
LEFT OUTER JOIN t_account_mapper ancparentmap
ON ancparentmap.id_acc = ancparent.id_ancestor and ancparentmap.nm_space
= accmap.nm_space
INNER JOIN t_namespace ns
ON ns.nm_space = accmap.nm_space
LEFT OUTER JOIN t_av_contact t_av_contact
ON t_av_contact.id_acc = acc.id_acc
INNER JOIN t_av_internal t_av_internal
ON t_av_internal.id_acc = acc.id_acc
INNER JOIN t_usage_cycle uc
ON uc.id_usage_cycle = accuc.id_usage_cycle
WHERE
(ancparent.vt_start IS NULL OR '15-mar-2002'BETWEEN ancparent.vt_start AND
ancparent.vt_end)
AND EXISTS (SELECT null FROM t_account_ancestor anccorpfilter WHERE
anccorpfilter.id_descendent = acc.id_acc
AND '15-mar-2002'BETWEEN anccorpfilter.vt_start AND anccorpfilter.vt_end
AND (anccorpfilter.id_ancestor IN (137,193,219)
OR (anccorpfilter.id_ancestor = 1 and anccorpfilter.num_generations =
1)))
AND lower(accmap.nm_login) like 'ra%'
AND lower(ns.tx_typ_space) = 'system_mps'
AND rownum <= 11
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Harvinder Singh
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
