I have 3 table called 1.Sales, 2.sales_copy, 3.sales_log_err respectively i have more than 3 million sales record i want to copy allsales record into sales_copy table and at the same time i wan

I have 3 table
called
 1.Sales,
 2.sales_copy,
 3.sales_log_err
 respectively  i have more than 3 million sales record i want to copy allsales record into sales_copy table and at the same time i want to track all the rejected error data into  table-3 sales_log _err with a sequence number how it is possible in plsql.
Sales_copy table contains some validation constraints i want to filter the data please help.