Database Administration (MOSC)

MOSC Banner

ora_archive_state + dbms_redefinition

edited May 9, 2021 9:19AM in Database Administration (MOSC) 2 comments

I have an idea on how to implement a massive data cleanup of a complex database schema.

At first stage, the procedure would update tables setting ora_archive_state='1' using batches, iterating trough parent-child relationships.

At the second stage, dbms_redefinition would reorganize tables one-by-one getting rid of archived rows.

The problem is, dbms_redefinition does not support meaningful handling of ora_archive_state.

While trying to reorganize table with "row archival", dbms_redefinition just makes all rows of the resulting table unarchived.

What do you thing, would there be any sense to ask for an enhancement to dbms_redefinition to handle in-database row archiving?

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