Skip to main content

Change data partitions

The attrep_cdc_partitions table contains records of partitions created on the target database when Change Data Partitioning is enabled for a Replicate task. You can use this information to identify partitioned data that needs to be further processed.

attrep_cdc_partitions table fields
Column Type Description

SERVER_NAME

STRING

The name of the machine on which Replicate is installed.

TASK_NAME

STRING

The name of the Replicate task.

PARTITION_NAME

STRING

The partition name consists of the partition start and end time.

Example:

20170313T123000_20170313T170000

PARTITION_START_TIME

TIMESTAMP

When the partition was opened:

Example:

2017-03-13 12:30:00.000

PARTITION_END_TIME

TIMESTAMP

When the partition was closed:

Example:

2017-03-13 17:00:00.000

TABLE_OWNER

STRING

The table schema or owner.

TABLE_NAME

STRING

The table name.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!