SQL & PL/SQL :: Transferring Data From One To Another Database

In production database 30 tables are there in different schemas.

In some tables data is existed for 5 years
in some tables data is existed 8 years
in some tables data is existed for 6 years.

And all these tables are having billions and millions of records.Let us assume the tables in the production database are

Table1 -- 8 years data -- No. Of Records 3538969000
Table2 -- 6 years data -- No. Of Records 592844435
Table3 -- 3 years data -- No. Of Records 33224993
Table4 -- 4 years data -- No. Of Records 52361756
Table5 -- 5 years data -- No. Of Records 8948567
Table15 -- 6 years data -- No. Of Records 308476987

Now I want to trnasfer these 15 tables data to test database.Based on the following conditions.

For Table1 I want to transfer 6 years data to test database, keeep 2 years data in production and delete all 6 years data from production databse.

For Table2 I want to transfer 4 years data to test database, keeep 2 years data in production and delete all 4 years data from production databse.

For Table3 I want to transfer 2 years data to test database keeep 1 years data in production and delete all 2 years data from production databse.

This will be done periodically.

I.e. suppose if we run the script now and transfer the requested data to test database,again after one year the data got increased in production then again we have to run the script and transfer data to test database based on some conditions,so it should work for long time. what is the good and fast process to transfer the data.