Database Utilities (MOSC)

MOSC Banner

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."

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