alter sql profile to force matching
- From: joshuasingham <joshuasingham@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 27 Apr 2010 15:44:28 +0800
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:
