there are two databases X and Y
a. Create an SP to
i. read the records from X.A_B_C_FILE
and insert into USER.D_FILE
ii. read the records from X.SOME_SOME
and insert into USER.SOME1_SOME1
and update them with the run_i created in the step above
iii. call the SP in X to truncate the SOME_SOME