I have one table that was over 100G and I only need to keep 1 year of current data, the rest can be archived. What is the best way to handle this situation.

I am thinking to move everything except one year of archived data to a file and used External table if someone needs to look at it.

thoughts?