Database Administration (MOSC)

MOSC Banner

Archiving large tables

Hi guys, I've receive a request to perform archiving on a few very large tables. These tables are mainly keeping the application historical logs. The largest table is about 200GB in size and roughly about 200mil rows while smallest is about 4GB in size and about 1.4mil rows.

Now my normal practice is to use CTAS based on the date range for each table this will allow me to copy data older than x year to a backup table then I'll drop the old data from existing table using DELETE FROM statement.

However for such big table it will take hours of processing power to complete. I do have backups on those databases, however my application guys request the data to be on the database incase they need to retrieve on the fly.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center