| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | |
|---|---|---|---|---|---|---|---|---|---|
Generate and Run the Supplemental Logging Script |
Generate and Run the Supplemental Logging Script |
chugugrace |
chugu |
03/01/2017 |
sql |
integration-services |
conceptual |
|
[!INCLUDE oracle-cdc-retirement]
Use the Set up Tables for Capturing Changes page to run a script on the Oracle source database that will set up supplemental logging.
To run the supplemental logging scripts
Click Run Script to run the supplemental logging script on the tables defined for the CDC instance. This script instructs the Oracle database to write all columns of interest to its transaction logs when logging UPDATE operations to captured tables. This script is normally examined and executed by an Oracle system administrator.
You can also run the scripts manually using SQL * Plus.
To run the scripts manually
Click Copy to paste the script to the clipboard. Open SQL* Plus and go to the directory with your Oracle source database. Paste the script into SQL*Plus to run it.
To save the supplemental logging script in a text file, click Save as and browse to the location where you want to save the file. Give the file a name and click Save to save the file.
Click Next to Generate Mirror Tables and CDC Capture Instances.
How to Create the SQL Server Change Database Instance
Review and Generate Supplemental Logging Scripts