Schema Changes Without the Downtime: Using Oracle DBMS_REDEFINITION
Stop locking production tables for schema changes. Learn how to use Oracle DBMS_REDEFINITION to add columns or change compression online while keeping your application active.
ReadMeFeed / Community knowledge
Real questions. Useful conversations. Find the people who know your stack.
Stop locking production tables for schema changes. Learn how to use Oracle DBMS_REDEFINITION to add columns or change compression online while keeping your application active.
A production tablespace needs TDE encryption without an export/import window. This post shows how to enable Oracle Transparent Data Encryption in place with online redefinition, wallet management, and verification without a full export/import.