Re: 10gR2 and _simple_view_merging issue

Thanks Tim,

are there any doco references handy? Nothing on metalink, I checked all usual suspects. Any links would be helpful.

Thanks in advance
Raj

On 12/8/05, oracle-l_at_timothyhopkins.net <oracle-l_at_timothyhopkins.net> wrote:
>
> Raj,
>
> That sounds like the expected behaviour to me. Setting that parameter
> to FALSE is equivalent to using the NO_MERGE hint against the view,
> which is expected to produce the error you're receiving. See below for
> an example which demonstrates this is the expected behaviour. Note
> that it isn't possible to selectively override the parameter using the
> MERGE hint.
>
> I'd recommend leaving the parameter set to TRUE then include the
> NO_MERGE hint where necessary in the views which had the original
> performance issues.
>
>

--
http://www.freelists.org/webpage/oracle-l