Hi Jeffrey,
Interesting, maybe I'm wrong, but as far as I
remember, SYS.DBMS_SQLDIAG_INTERNAL.i_create_patch has never had
"force_match" parameter and moreover it wasn't officially supported in 11.2
Unfortunately, I have no databases <12.1.0.2 anymore.
But you still can use DBMS_SQLTUNE_INTERNAL.I_CREATE_SQL_PROFILE with
parameters: TYPE => 'PATCH', IS_PATCH => true, FORCE_MATCH=>true
On Wed, Sep 23, 2020 at 7:40 PM Jeffrey Beckstrom <jbeckstrom@xxxxxxxxx>
wrote:
In 11g, when creating a sql patch, there was an option for force matching.
In our 12.2 database, I no longer see that option. Is there a way to
specify force matching when creating a sql patch?
Jeffrey Beckstrom
Lead Database Administrator
Information Technology Department
Greater Cleveland Regional Transit Authority
1240 W. 6th Street
Cleveland, Ohio 44113