选择 Oracle 表和列Select Oracle Tables and Columns

适用于:Applies to: 是SQL ServerSQL Server(所有支持的版本)yesSQL ServerSQL Server (all supported versions) 是 Azure 数据工厂中的 SSIS Integration RuntimeSSIS Integration Runtime in Azure Data Factoryyes Azure 数据工厂中的 SSIS Integration RuntimeSSIS Integration Runtime in Azure Data Factory适用于:Applies to: 是SQL ServerSQL Server(所有支持的版本)yesSQL ServerSQL Server (all supported versions) 是 Azure 数据工厂中的 SSIS Integration RuntimeSSIS Integration Runtime in Azure Data Factoryyes Azure 数据工厂中的 SSIS Integration RuntimeSSIS Integration Runtime in Azure Data Factory

使用“选择 Oracle 表和列”页可以从捕获了更改的 Oracle 源数据库选择表。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 表名称:表的名称,包括表架构。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. 捕获实例不能为 NULL。The capture instance cannot be NULL.

    如果未指定,则该名称将从源架构名称加上源表名称中派生而来,格式为 <schema-name>_<table-name>If not specified, the name is derived from the source schema name plus the source table name in the format <schema-name>_<table-name>. 捕获实例名称不能超过 100 个字符,并且在数据库中必须是唯一的。The capture instance name cannot exceed 100 characters and must be unique within the database.

    可单击此列的任意单元格对 capture_instance 进行手动编辑。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.

    可单击此列的任意单元格对 security_role 进行手动编辑。You can click in any cell in this column to manually edit the security_role.

添加表Add Tables
单击“添加表”可打开“表选择”对话框,从中你可以为捕获更改选择 Oracle 表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
从该列表中选择一个表,然后单击“删除”可从 CDC 实例中删除该表。Select a table from the list and click Remove to remove the table from the CDC instance.

在使用正确的对话框为捕获更改选择 Oracle 表对为捕获更改选择的表进行更改后,单击“下一步”以生成和运行补充日志记录脚本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

如何创建 SQL Server 更改数据库实例 How to Create the SQL Server Change Database Instance
编辑表 Edit Tables
将表添加到 CDC 实例 Add Tables to a CDC Instance
编辑表属性Edit the Table Properties