solidDB Help : solidDB reference : SQL: Statements : CREATE REPLICATION PARTITION
  
CREATE REPLICATION PARTITION
CREATE REPLICATION PARTITION name [(table‑element [column‑list]
   [WHERE where‑clause] [, table‑element …])]
where:
table-element::= [[catalog-name.]schema-name.]table-name
column‑list:: = (column‑name [, column‑name …])
where‑clause::= colname (predicate constant | IS [NOT] NULL) [AND where‑clause]
predicate::= {= | <> | > | < | >= | <=}
Note This statement replaces the previous CREATE LOGREADER PARTITION statement.
Access requirements
SYS_ADMIN_ROLE role
Usage
Use the CREATE REPLICATION PARTITION statement to define a replication partition (one or more tables within a database that are available for replication).
SYS_FEDT_DB_PARTITION includes information about replication partitions in the solidDB server, see SYS_FEDT_DB_PARTITION.
SYS_FEDT_TABLE_PARTITION includes information about tables that belong to replication partitions, see SYS_FEDT_REPLICA_SERVER.
Return values
 
Error code
Description
13011
Table does not exist. Partition can only contain tables that exist in the catalog, and in the schema where partition is created.
13408
Logreader feature is disabled. Logreader feature is needed by C Replicator. Check that configuration parameter [LogReader]LogReaderEnabled=Yes is set in the solid.ini for the source server.
13416
Logreader partition already exists. Partition names must be unique. Drop conflicting partition, or rename the new partition, and retry.
13419
Invalid partition filter. Check the syntax, and that operations used in where clause are supported.
13420
Syntax error
Examples
solsql> create replication partition share2 (tab1);
Command completed successfully, 0 rows affected.
solsql> create replication partition share2 (tab1);
SOLID Table Error 13416: Logreader partition already exists
Go up to
SQL: Statements