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.