Oracle教程

Oracle 视图 DBA_GOLDENGATE_NOT_UNIQUE 官方解释，作用，如何使用详细说明

本站中文解释

_CONTAINERS

Oracle视图DBA_GOLDENGATE_NOT_UNIQUE_CONTAINERS用于检查GoldenGate唯一容器的唯一性。它从GoldenGate文件从中获取每个配置中的容器的重复使用。该视图返回每个容器的名称，类型，路径，和容器中的文件大小。

使用方法：

1. 首先，从Oracle Database中运行该视图；

SQL> SELECT * FROM dba_goldengate_not_unique_containers;

2. 最后，检查返回的结果并确认唯一容器的唯一性。

官方英文解释

DBA_GOLDENGATE_NOT_UNIQUE displays all tables that have no primary and no non-null unique indexes.

Most of the tables displayed by this view are supported because their columns contain enough information to be maintained by Oracle GoldenGate. Some tables, however, cannot be supported because their columns do not contain the necessary information. Unsupported tables usually contain a column defined using an unsupported data type.

Column Datatype NULL Description

OWNER

VARCHAR2(128)

Schema name of the non-unique table

TABLE_NAME

VARCHAR2(128)

Table name of the non-unique table

BAD_COLUMN

VARCHAR2(1)

Indicates that the table has a column not useful in the where clause. Possible values:

  • Y – Table column is defined using an unbounded data type, such as LONG or BLOB. If two rows in the table match except in their LOB columns, then the table cannot be maintained properly. Log apply services will attempt to maintain these tables, but you must ensure the application does not allow uniqueness only in the unbounded columns.

  • N – Enough column information is present to maintain the table in Oracle GoldenGate but the log transport services and log apply services would run more efficiently if you added a primary key. You should consider adding a disabled RELY constraint to these tables.


数据运维技术 » Oracle 视图 DBA_GOLDENGATE_NOT_UNIQUE 官方解释，作用，如何使用详细说明
分享到：

相关推荐