Re: sql patch with force matching

From: Sayan Malakshinov <>
Date: Wed, 23 Sep 2020 20:28:10 +0300
Message-ID: <>

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 < 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 <> 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

Best regards,
Sayan Malakshinov
Oracle performance tuning engineer
Oracle ACE Associate

Received on Wed Sep 23 2020 - 19:28:10 CEST

Original text of this message