owner |
Name of the schema that owns the change table. |
change_table_name |
Name of the change table that is being created. |
change_set_name |
Name of an existing change set with which this change table is associated. Synchronous change tables must specify SYNC_SET. |
source_schema |
The schema where the source table is located. |
source_table |
The source table from which the change records are captured. |
column_type_list |
Comma-separated list of columns and datatypes that are being tracked. |
capture_values |
Set this parameter to one of the following capture values for update operations: |
|
Value
OLD |
Description
Captures the original values from the source table. |
|
NEW |
Captures the changed values from the source table. |
|
BOTH |
Captures the original and changed values from the source table. |
rs_id |
Adds a column to the change table that contains the row sequence number. This parameter orders the operations in a transaction in the sequence that they were committed in the database. The row sequence ID (rs_id ) parameter is optional for synchronous mode.
Note: For synchronous mode, the rs_id parameter reflects an operations capture order within a transaction, but you cannot use the rs_id parameter by itself to order committed operations across transactions.
Set this parameter to Y or N, as follows: |
|
Value
Y
|
Description
Indicates that you want to add a column to the change table that will contain the row sequence of the change. |
|
N |
Indicates that you do not want to track the rs_id column. |
row_id |
Adds a column to the change table that contains the row ID of the changed row in the source table, as follows. |
|
Value
Y |
Description
Indicates that you want to add a column to the change table that contains the row ID of the changed row in the source table. |
|
N |
Indicates that you do not want to track the row_id column. |
user_id |
Adds a column to the change table that contains the user name of the user who entered a DML statement, as follows. |
|
Value
Y |
Description
Indicates that you want to add a column to the change table that contains the user name of the user who entered a DML statement. |
|
N |
Indicates that you do not want to track users. |
timestamp |
Adds a column to the change table that contains the capture timestamp of the change record, as follows: |
|
Value
Y |
Description
Indicates that you want to add a column to the change table that contains the capture timestamp of the change record. |
|
N |
Indicates that you do not want to track timestamps. |
object_id |
Adds a column to the change table that contains the object ID of this change record. This is a control column for object support. Specify Y or N, as follows: |
|
Value
Y |
Description
Indicates that you want to add a column to the change table that contains the object ID of this change record. |
|
N |
Indicates that you do not want to track object IDs. |
source_colmap |
Adds a column to the change table as a change column vector that indicates which source columns actually changed. Specify Y or N, as follows: |
|
Value
Y |
Description
Indicates that you want to add a column to the change table to track the source columns that have changed. |
|
N |
Indicates that you do not want to track which source columns changed. |
target_colmap |
Adds a column to the change table as a column vector indicating which change table user columns actually changed. Specify Y or N, as follows. |
|
Value
Y |
Description
Indicates that you want to add a column to the change table to track the change table user columns that have changed. |
|
N |
Indicates that you do not want to track changes which change table user columns changed. |
options_string |
A string that contains syntactically correct options to be passed to a CREATE TABLE DDL statement. The options string is appended to the generated CREATE TABLE DDL statement after the closing parenthesis that defines the columns of the table. See the Usage Notes for more information. |