Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table tbl (col number unique) row archival
insert into tbl
    select rownum from dual connect by level<=3; 
3 rows affected

commit;
update tbl set ora_archive_state='20' where col=1
1 rows affected

select * from tbl

COL

2

3

insert into tbl values (1)
ORA-00001: unique constraint (FIDDLE_ZWWRLNAMMSGONIEDQMXP.SYS_C0081616) violated

alter session set row archival visibility=all
select t.*, ora_archive_state from tbl t

COL
ORA_ARCHIVE_STATE

1
20

2
0

3
0