Is there a limit as to the number of columns that a table can have in replication? (4247711)

The question arises whether there a limit as to the number of columns that a table can have in replication.

General information.

There is no limit imposed by Shareplex on the # of columns it can handle in a table. So whatever limit is imposed by the native database implementation (currently only Oracle) is fine with Shareplex. If such tables have a very large number of rows, this may require special considerations during activation, resync, etc, but that is another point.

This para describes the current limit of the # of tables in Oracle. The absolute maximum number of columns in a table is 1000. However, when one creates an object table (or a relational table with columns of object, nested table, varray, or REF type), Oracle maps the columns of the user-defined types to relational columns, creating in effect hidden columns that count toward the 1000-column limit. For details on how Oracle calculates the total number of columns in such a table, refer to Oracle Database Administrators Guide.