If a table was not created with a primary or unique key, you can specify columns to use as a key when you specify the object in the configuration file. SharePlex uses the specified columns as a unique key in its WHERE clause to locate target rows for posting.
NoteS:
|
The columns that you specify as a key must meet the following criteria:
To create a key definition, type a space after the source object and use the following syntax, including the parentheses.
src_owner.table !key (column_list)
where:
datasource_specification |
||
src_owner.table !key (col_name, col2_name, ...) |
tgt_owner.table |
host@o.SID |
Datasource:o.ora1 scott.tab !key(name,ID) scott.tab2 sysB@oraB
The columns that you specify as a key must meet the following criteria:
A unique key cannot be TEXT, BYTEA, JSON, JSONB, CHAR with more than 2000 characters, VARCHAR without size or more than 4000 characters.
They must be part of the column partition if the table is configured for vertically partitioned replication. When using the exclude column notation in vertical partitioning, the excluded columns cannot be used in the key definition. For more information, see Configure Partitioned Replication.
To create a key definition, type a space after the source object and use the following syntax, including the parentheses.
src_schema.table !key (column_list)
where:
datasource_specification |
||
src_schema.table !key (col_name, col2_name, ...) |
tgt_schema.table |
host@r.dbname |
Datasource:r.dbname scott.tab !key(name,ID) scott.tab2 sysB@dbname
The columns that you specify as a key must meet the following criteria:
A unique key cannot be text, char with more than 2000 characters, varchar without size or more than 4000 characters.
To create a key definition, type a space after the source object and use the following syntax, including the parentheses.
src_schema.table !key (column_list)
where:
datasource_specification |
||
src_schema.table !key (col_name, col2_name, ...) |
tgt_owner.table |
host@o.SID |
Datasource:r.dbname "scott"."tab" !key(name,ID) "scott"."tab2" sysB@o.oraB
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Términos de uso Privacidad Cookie Preference Center