Skip to Main Content

Write Great SQL Office Hours

Free tips and training every month! Subscribe for reminders and more from Office Hours. FAQ

Header container

May 17, 2022

13:00 UTC   Start Times Around the World

Subscribe to be notified of changes to sessions and give us feedback!

Having trouble watching the video on this page? Open the video in your browser.


How to archive old data
As applications mature there is often a need to archive old data. This could be to reduce storage costs, improve query performance or meet regulatory requirements.

But adding archival routines is a daunting task. The processes to remove old data can be complex to write and take a long time to run. So often this work is deferred, leading to colossal tables that are increasingly hard to manage.

Join this session to learn strategies to quickly and easily wipe the oldest rows in tables.

Highlights include:

01:30 - What is archiving?
05:25 - Why archive?
14:50 - Using DDL to make DELETE faster
15:50 - "Delete" methods performance comparison
19:20 - How to add partitioning to a table
24:40 - Using partition exchange to move data to archive tables
34:50 - Handling child rows when archiving data
38:00 - Reference partitioning
42:20 - What is In-Database Archiving
47:40 - Demo of adding partitioning to tables and using partition exchange to archive data

Your Experts

    Chris Saxon

    Chris Saxon   

    Chris Saxon is an Oracle Developer Advocate and quizmaster on Dev Gym. His job is to help you get the best out of the Oracle Database and have fun with SQL! He's also part of the answer team on Ask TOM and creates YouTube videos at The Magic of SQL channel.