Select Oracle Tables and Columns

Applies to: yesSQL Server (all supported versions) yes SSIS Integration Runtime in Azure Data Factory

Use the Select Oracle Tables and Columns page to select the tables from the Oracle source database where changes are captured. This page has the following elements:

Options

Table list
The table list has three columns:

  • Oracle Table Name: The name of the table, including the table schema.

  • Capture Instance: The name of the capture instance used to name instance-specific change data capture objects. The capture instance cannot be NULL.

    If not specified, the name is derived from the source schema name plus the source table name in the format <schema-name>_<table-name>. The capture instance name cannot exceed 100 characters and must be unique within the database.

    You can click in any cell in this column to manually edit the capture_instance.

  • Security Role: The name of the database gating role used to control access to change data.

    You can click in any cell in this column to manually edit the security_role.

Add Tables
Click Add Tables to open the Table Selection dialog box where you can Select Oracle Tables for Capturing Changes.

Edit
Select a table from the list and select Edit to open the Properties dialog box for that table where you can Make Changes to the Tables Selected for Capturing Changes.

Remove
Select a table from the list and click Remove to remove the table from the CDC instance.

After you Select Oracle Tables for Capturing Changes and/or Make Changes to the Tables Selected for Capturing Changes using the correct dialog boxes, click Next to Generate and Run the Supplemental Logging Script.

See Also

How to Create the SQL Server Change Database Instance
Edit Tables
Add Tables to a CDC Instance
Edit the Table Properties