ORA-02065: illegal option for ALTER SYSTEM with _allow_insert_with_update_check

Question

I am trying to alter but it is giving below error- (database version -12.2.0.4)

SQL> alter system set "_allow_insert_with_update_check"=true scope=both;

alter system set "_allow_insert_with_update_check"=true scope=both * ERROR at line 1: ORA-02065: illegal option for ALTER SYSTEM

Answer 1

Remove parenthesis alter system set _allow_insert_with_update_check=true scope=both

Answer 2

scope = spfile and then bounce the database.

Answer 3

use this command

alter system set "_allow_insert_with_update_check" = true;