How to keep 20% of the table and delete the rest from a 35 million row table
Oracle info: 18.104.22.168
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.
Click Here to Expand Forum to Full Width