Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

ORA-16292

cannot replicate ALTER TABLE ADD COLUMN with sequence default value

Cause

The logical standby database attempted to replicate an unsupported DDL statement. The DDL added a column with a sequence as the default with compatiblity set to a release earlier than 12.2.0.2.0.


Action

The table must be re-instantiated from the primary database using DBMS_LOGSTDBY.INSTANTIATE_TABLE().