Re: sql patch with force matching

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_at_gcrta.org> 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
http://orasql.org

--
http://www.freelists.org/webpage/oracle-l