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 >
