Unable to Create a Replication Scheme

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

Possible cause What to do

User does not have ADMIN privilege.

You must have ADMIN privilege to use the CREATE REPLICATION or DROP REPLICATION statements.

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

  • Check the CREATE REPLICATION statement for typographical errors.

  • See Check Host Names for information.

  • Use official host names instead of aliases.

  • The host name should match the value returned by the hostname command on your system and should be used consistently throughout the replication scheme.

The local host is not part of the replication scheme.

Create the replication scheme on a host that will be part of the replication scheme.

Replication tables defined in the CREATE REPLICATION statement do not exist.

The name, owner, and column definitions of the tables participating in the replication scheme must be identical on both the master and subscriber databases. Use CREATE TABLE to create tables on the database, or use the ttRepAdmin -duplicate utility or the ttRepDuplicateEx C function to duplicate the entire database to be replicated.

There are other problems.

Review the procedures and requirements described in Defining Classic Replication Schemes in the Oracle TimesTen In-Memory Database Replication Guide.