You can use Data Transmission Service (DTS) to track data changes from databases in real time. You can use the change tracking feature in the following scenarios: lightweight cache updates, business decoupling, asynchronous data processing, and synchronization of extract, transform, and load (ETL) operations. This topic describes how to create a change tracking task to track data changes from a self-managed Oracle database.
Prerequisites
- The version of the self-managed Oracle database is 9i, 10g, or 11g. Real Application Cluster (RAC) or pluggable database (PDB) instances are not supported.
- Supplemental logging, including SUPPLEMENTAL_LOG_DATA_PK and SUPPLEMENTAL_LOG_DATA_UI, is enabled for the self-managed Oracle database. For more information, see Supplemental Logging.
- The self-managed Oracle database is running in ARCHIVELOG mode. Archived log files are accessible and a suitable retention period is set for archived log files. For more information, see Managing Archived Redo Log Files.
Limits
Category | Description |
---|---|
Limits on the source database |
|
Other limits |
|
Preparations
Log on to the source Oracle database, create a database account, and grant the database administrator (DBA) permission to the account. For more information, see CREATE USER and GRANT.
Procedure
What to do next
- Create and manage consumer groups. For more information, see Create consumer groups.
- Use one of the following methods to consume the tracked data: