Partitioned View Select problems.

From: Richard Murphy <rmurphy_at_lbpc.com>
Date: Tue, 16 Feb 1999 16:37:41 -0600
Message-ID: <36C9F335.5A2B387@lbpc.com>

ERROR at line 2:
ORA-00600: internal error code, arguments: [12337], [], [], [], [], [], [], []

The statement is:
SELECT COUNT(*) FROM CD_ENTITLEMENT
WHERE (JURISDICTION = 139537 OR
JURISDICTION = 139529) AND RESTRICTED_FLAG IS NULL AND CASE_NUMBER = '99L 0000391' where the partitioned views is a combination of tables with various JURISDICTIONs. The statement ONLY gives me a problem when i include CASE_NUMBER, which is part of the primary key. I have no problems if i use only one JURISDICTION and CASE_NUMBER or multiple JURISDICTIONs and no CASE_NUMBER.

Anyone know what is going on and how to fix it?

Thanks, R. Received on Tue Feb 16 1999 - 16:37:41 CST