Http://blog.itpub.net/28258625/viewspace-2060713 This knowledge document describes a best p
Http://blog.itpub.net/28258625/viewspace-2060713
This knowledge document describes a best practice method for handling tables without primary keys or unique indexes when using oracle GoldenGate to replicate transactional data between Oracle databases.
There is a change log at the end of this document.
This document is divided into the following sections:
Appendix A: Sample Table Configuration
In order to maintain data integrity when replicating transactional data, Oracle GoldenGate will use primary key columns or unique index columns to uniquely identify a row when issuing update or delete statements against the target database. If no primary keys or unique indexes exist on the table being replicated, Oracle GoldenGate will use all columns to uniquely identify a row.
It is perfectly acceptable to use all columns to uniquely identify a row under the following conditions:
If the table being replicated does not meet all of the conditions listed above, it is recommended to add a column to the table with a SYS_GUID default value to uniquely identify the row. The next section describes the detailed steps on how to configure a table without a primary key or unique index in order to uniquely identify each row.
Software Component | Minimum Version |
---|---|
Oracle Database |
10.2 or greater |
Oracle GoldenGate | 10.4 or greater |
2.1 Configure Table(s) in Source Database
Before instantiating the target database from a copy of source, perfORM. the following steps to the table(s) without primary keys or unique indexes.
Step 1 - Add Column to Table
Issue the following command to add the column to the table.
Replace <table_name> with the table name being modified.
--结束END--
本文标题: Oracle GoldenGate 针对表没有主键或唯一索引的解决方案
本文链接: https://www.lsjlt.com/news/49273.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-05-03
2024-05-03
2024-05-03
2024-05-03
2024-05-03
2024-05-03
2024-05-03
2024-05-03
2024-05-03
2024-05-03
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0