Re: Partitioned View Select problems.

From: Christopher M. Day <christopher.day_at_rdbms.freeserve.co.uk>
Date: Wed, 17 Feb 1999 00:01:00 +0000
Message-ID: <36CA06BC.7D5AD3C9@rdbms.freeserve.co.uk>

Richard,

Can you post the version of Oracle you are running.

Thanks

Chris.

Richard Murphy wrote:
>
> 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 - 18:01:00 CST