Table Types

Enterprise Replication has restrictions on the types of tables that can participate in replication.

The following table types are not supported by Enterprise Replication:
  • RAW tables
  • Temporary tables

    Because the database server deletes temporary tables when an application terminates or closes the database, do not include these tables in your replication environment.

Enterprise Replication imposes the following operational limitations:

  • Replication is restricted to base tables. That is, you cannot define a replicate on a view or synonym. A view is a synthetic table, a synthesis of data that exists in real tables and other views. A synonym is an alternative name for a table or a view. For more information about views and synonyms, see the HCL OneDB™ Database Design and Implementation Guide.
  • Replication is not inherited by any child tables in a typed hierarchy.

For more information about table types, see HCL OneDB Database Design and Implementation Guide.