ORA-02065: illegal option for ALTER SYSTEM with _allow_insert_with_update_check

1.9k Views Asked by At

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

3

There are 3 best solutions below

0
sarat On

Remove parenthesis alter system set _allow_insert_with_update_check=true scope=both

1
user19503464 On

scope = spfile and then bounce the database.

0
Alireza Balavand On

use this command

alter system set "_allow_insert_with_update_check" = true;