Home | Previous Page | Next Page   Setting Up and Managing Enterprise Replication > Managing Replication Servers and Replicates > Performing Alter Operations on Replicated Tables >

Attaching a New Fragment to a Replicated Table

To attach a new fragment, you must first manually place the replicated table in alter mode using the cdr alter command (described in Appendix A. Command-Line Utility Reference). Enterprise Replication cannot automatically set alter mode for this operation due to an SQL restriction that requires attaching a fragment to be performed in multiple steps.

To attach a new fragment to a replicated table
  1. Set alter mode on the replicate using the cdr alter command.
  2. Drop the primary key of the table.
  3. Attach the new fragment.
  4. Re-create the primary key.
  5. Unset alter mode using the cdr alter command.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]