Re: ** outline change
From: Riyaj Shamsudeen <riyaj.shamsudeen_at_gmail.com>
Date: Wed, 18 Mar 2009 10:07:11 -0500
Message-ID: <203315c10903180807q3ae5910bw94aec80838200899_at_mail.gmail.com>
Hi Joshi
Date: Wed, 18 Mar 2009 10:07:11 -0500
Message-ID: <203315c10903180807q3ae5910bw94aec80838200899_at_mail.gmail.com>
Hi Joshi
Have you reviewed document *730062.1? *That document is the correct way to manipulate outlines.
-- Cheers Riyaj Shamsudeen Principal DBA, Ora!nternals - http://www.orainternals.com Specialists in Performance, Recovery and EBS11i Blog: http://orainternals.wordpress.com On Wed, Mar 18, 2009 at 9:12 AM, A Joshi <ajoshi977_at_yahoo.com> wrote: Hi,Received on Wed Mar 18 2009 - 10:07:11 CDT
> I want to update a stored outline to change the join method. Is there a way
> it can be done from sqlplus instead of from OEM or tool. Using just unix
> sqlplus access. I looked at DBMS_OUTLN package but nothing in it. I do see
> tables like outln.ol$hints and the outline in it but I do not want to do a
> sqlplus update on it without knowing the full impact. I cannot change the
> query with hint etc since it is a indirect query. So I cannot give hint etc
> and exchange plan. Thanks for help. In TOAD : it says there is outline
> management but I cannot find it. Thanks
>
>
-- http://www.freelists.org/webpage/oracle-l