-
Best way to archive old data
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?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|