Oracle 19: dbms_redefinition on a table with an identity column
Oracle 19 on Linux Redhat
I am trying to use dbms_redefinition on a table with an identity column. The identity column is defined as " generated by default on null as identity" and is also the (only) column of the primary key constraint for the table.
I create a copy of the original table with the same definition for the table, the identity column, and the primary key constraints. dbms_redefinition.can_redef_table (cons_use_pk option) gives no errors.
dbms_redefinition.start_redef_table (I am NOT using the col_mapping option) returns ORA-23550
Support Doc ID 2797057.1 says "Online redefinition is not supported if the interim table has an IDENTITY column. By design it will raise ORA-23550 as it's expected behavior."