I would like to write a procedure to insert data from Table A to Table B. (Table A and Table B are large tables with hundreds of millions of rows) Table A is a normal table and has fields x,y,z; Table B is a Daily partitioned table and has fields x,y,z,t,k.
The procedure should commit for each 10.000 rows insert and call another procedure PRX in loop. Duplicate values will simply be ignored and operation will continue as well.
Could you please help me?