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).