Hello,
It tried it but it is impossible with the packages DBMS_ADVANCED_REWRITE and DBMS_SQL_TRANSLATOR to remove one hint fom a SELECT.
I showed my test case here : https://asktom.oracle.com/pls/apex/asktom.search?tag=remove-a-hint-with-dbms-advanced-rewrite-and-dbms-sql-translator-fa…
Chris said that I can use "alter session set optimizer_ignore_hints = true;" : it works but the problem is that it will erase ALL the hints from a SELECT.
OK, I know, hint is bad but sometimes developers do what they want.
So, do you think it is a good idea to ask Oracle to enhance these both packages?
Have a nice day,
David