Oracle DBMS_REDEFINITION: Unresolved Referential Constraint Transfer During Online Redefinition
When using Oracle DBMS_REDEFINITION for online table redefinition of a small application, the precise goal is to migrate schema changes or data reorganization without locking the source table or requiring a full export-import cycle. However, Oracle does not automatically transfer referential constraints, check constraints, or their enabled/disabled and defer