TimesTen Error Messages

TT-02418

Cannot add not null column column_name to replicated table owner_name.table_name

Cause

You attempted to use the ALTER TABLE statement to add a NOT NULL column to a table that is part of a replication scheme.

Action

  1. Drop the table from the replication scheme. For more information, see Dropping a Table or Sequence from a Classic Replication Scheme in Oracle TimesTen In-Memory Database Replication Guide.
  2. Add the NOT NULL column to the table with ALTER TABLE. For more information see ALTER TABLE in the Oracle TimesTen In-Memory Database SQL Reference.
  3. Add the table back into the replication scheme.

For more information, see Adding a Table or Sequence to an Existing Classic Replication Scheme in the Oracle TimesTen In-Memory Database Replication Guide.

Additional Information

You cannot use the ALTER TABLE statement to add a NOT NULL column to a table that is replicated.