Select Oracle Tables and Columns
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:
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.
Click Add Tables to open the Table Selection dialog box where you can Select Oracle Tables for Capturing Changes.
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.
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.