Table Archival strategy

Hi

i need to archive the tables based on the following conditions, please let me know your inputs,

select * from test;

300 million rows

select * from test_2;

10 million rows

i would need to archive the test table based on this condition,

select a,col1,count(*) from test a, test_2 b where

    a.col1 =b.col1

and a.col2=b.col2

and b.col3 = 'A'

and b.col4 <> 'B'

group by a.col1

Thanks!