Re: alter sql profile to force matching

http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_sqltun.htm#i1008294

Seems that you can only alter following attributes - STATUS, NAME,
DESCRIPTION, CATEGORY.
<http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_sqltun.htm#i1008294>
================================
Dion Cho - Oracle Performance Storyteller

http://dioncho.wordpress.com (english)
http://ukja.tistory.com (korean)
http://dioncho.blogspot.com (japanese)
http://ask.ex-em.com (q&a)
================================


2010/4/27 joshuasingham <joshuasingham@xxxxxxxxx>

> Hi all,
>
> I have been trying to alter my sql profile to force match but was unable to
> get it to work according to the document link below  it say it is possible
> but I keep getting the error below any help is appreciated
>
> http://download.oracle.com/docs/cd/B19306_01/server.102/b14211/sql_tune.htm#CHDDABDE
>
> SQL> BEGIN
>   2    DBMS_SQLTUNE.ALTER_SQL_PROFILE(
>   3       name            => 'SYS_SQLPROF_0146a31c146a31c5',
>   4       attribute_name  => 'FORCE_MATCH',
>   5       value           => 'YES');
>   6  END;
>   7  /
> BEGIN
> *
> ERROR at line 1:
> ORA-13835: invalid attribute name specified
> ORA-06512: at "SYS.DBMS_SQLTUNE_INTERNAL", line 7132
> ORA-06512: at "SYS.DBMS_SQLTUNE", line 5603
> ORA-06512: at line 2
>

Other related posts: