How to keep 20% of the table and delete the rest from a 35 million row table

[raghu559]

Oracle info: 9.2.0.7
Hi all,

I'm planning to archive our production table which contain 35 million rows. I want to keep only 20% of the current table and move the rest to another archive table. I'm planning to do this by renaming the original table and creating a new table(original table_name) with 20% of the data using (create table as select *).

Are there any other efficient way to do this?

Thanks in advance.