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;