Re: 10G and RULE
From: Mark D Powell <Mark.Powell2_at_hp.com>
Date: Sat, 20 Mar 2010 06:01:34 -0700 (PDT)
Message-ID: <16ff32e1-3f80-4369-a6c5-f69e94a98eef_at_q16g2000yqq.googlegroups.com>
On Mar 20, 7:41�am, "Nicolas Bronke" <Nicolas_Bro..._at_web.de> wrote:
> With Oracle 10g the RULE command will not be supported.
> So far as good, we removed all RULE statements inside Queries and views.
> Mostly it works fine, but in some cases the queries does not work correcly.
> No rows are returned. If I put the RULE back in this query everything works
> fine.
> This happens with 20g2.0.3 and 10g2.0.4
>
> Does someone else has seen this and does exist a patch for this behaviour?
>
> Regards
> Nicolas
Date: Sat, 20 Mar 2010 06:01:34 -0700 (PDT)
Message-ID: <16ff32e1-3f80-4369-a6c5-f69e94a98eef_at_q16g2000yqq.googlegroups.com>
On Mar 20, 7:41�am, "Nicolas Bronke" <Nicolas_Bro..._at_web.de> wrote:
> With Oracle 10g the RULE command will not be supported.
> So far as good, we removed all RULE statements inside Queries and views.
> Mostly it works fine, but in some cases the queries does not work correcly.
> No rows are returned. If I put the RULE back in this query everything works
> fine.
> This happens with 20g2.0.3 and 10g2.0.4
>
> Does someone else has seen this and does exist a patch for this behaviour?
>
> Regards
> Nicolas
An actual example SQL showing both versions wtih results and the explain plan would likely be helpful. Also information on the type of table: heap, IOT, partitioned involved in the query is useful.
We have 10.2.0.3 and have not seen this.
Performance issues are common after upgrading to 10g from a lower version but changes in the query results are not.
HTH -- Mark D Powell -- Received on Sat Mar 20 2010 - 08:01:34 CDT