Unable to Alter a Replication Scheme

This section describes what to check if you are unable to use ALTER REPLICATION to alter a replication scheme.

Possible cause What to do

User does not have ADMIN privilege.

You must have ADMIN privilege to use the ALTER REPLICATION statement.

Replication agent is in Start state.

Most ALTER REPLICATION operations are supported only when the replication agent is stopped (ttAdmin -repStop). Stop the replication agents on both master and subscriber databases, alter the replication scheme on both master and subscriber databases, then restart both replication agents.

Database name, host name, or element name is inconsistent.

  • Check ALTER REPLICATION statement for typographical errors.

  • See Check Host Names for information.

Replication table defined in the ALTER REPLICATION statement does not exist.

Use CREATE TABLE to create a table on the database.

There are other problems.

Review the procedures and requirements described in Altering a Classic Replication Scheme in the Oracle TimesTen In-Memory Database Replication Guide.