create table dropme_src(id, val) as select rownum, cast(rpad('x',mod(rownum,8)+1,'y') as varchar2(10)) from dual connect by level < 17;
Table created

select * from dropme_src;
   ID VAL
----- ----------
    1 xy
    2 xyy
    3 xyyy
    4 xyyyy
    5 xyyyyy
    6 xyyyyyy
    7 xyyyyyyy
    8 x
    9 xy
   10 xyy
   11 xyyy
   12 xyyyy
   13 xyyyyy
   14 xyyyyyy
   15 xyyyyyyy
   16 x
16 rows selected

create table dropme_tgt(id integer, val varchar2(5));
Table created

exec dbms_errlog.create_error_log('dropme_tgt','dropme_tgt_err');
PL/SQL procedure successfully completed

insert into dropme_tgt
select * from dropme_src
log errors into dropme_tgt_err
reject limit unlimited
;
10 rows inserted

select ORA_ERR_NUMBER$, id, val from dropme_tgt_err;
ORA_ERR_NUMBER$ ID    VAL
--------------- ----- ----------
          12899 5     xyyyyy
          12899 6     xyyyyyy
          12899 7     xyyyyyyy
          12899 13    xyyyyy
          12899 14    xyyyyyy
          12899 15    xyyyyyyy
6 rows selected

SQL>