alter table enable constraint exceptions into exception

Hello all

I am trying this in oracle 11.2.0.3

alter table aivs.crdmbr_vldtn_evnt_log enable constraint CRDMBR_VLDTN_EVNT_LOG_PK exceptions into aivs.exceptions ;

Table altered.

insert into aivs.crdmbr_vldtn_evnt_log (CRDMBR_VLDTN_REQ_ID) values (2617)
;
insert into aivs.crdmbr_vldtn_evnt_log (CRDMBR_VLDTN_REQ_ID) values (2617)
*
ERROR at line 1:
ORA-00001: unique constraint (AIVS.CRDMBR_VLDTN_EVNT_LOG_PK) violated

select * from aivs.exceptions;

no rows selected

My understanding is that the exception clause would write information about the rows that violated a constraint on this table into the exception table. However after I tried to insert a duplicate row into my table, the row was rejected, but nothing was written into the exceptions table. Am I misunderstanding something or am I doing something incorrectly? My goal is to have duplicate records rejects AND written into the exception table , but I don't see it being the case