Re: ** outline change

  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,


> 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