insert LOG ERRORS INTO

1,创建错误表:

exec dbms_errlog.create_error_log(dml_table_name => 'etl_scv_cust_t',err_log_table_name => 'etl_scv_cust_t_errlog');

2, insert  sql:

insert into etl_scv_cust_t  select *    from temp LOG ERRORS    INTO etl_scv_cust_t_errlog('test') REJECT LIMIT UNLIMITED;