GoldenGate Version: 12.2.0.1
RDBMS version: 11.2.0.4
Operating System : Oracle Linux 6.4
In my Siebel schema, I have around 4000 tables and I would like to replicate around 450 tables in a remote DB.
None of these tables have Primary Keys or Unique Keys . But, these tables have a column named ROW_ID (not to be confused with the rowid which is internal to oracle RDBMS ). ROW_ID column values are unique. This is how a typical Siebel schema is designed.
ROW_ID column has values like the following
+------------+------------+
| ROW_ID | Cust_name |
+------------+------------+
| 1-U9203 | John |
| 1-A4389 | Sarah |
| 2-B8226 | Liz |
.
.
.
.
ROW_ID column has a unique index in it. I know that Goldengate cannot replicate tables without primary keys. But what about the above table with Unique index but no Primary key or Unique key in it ? Can Goldengate replicate these kind of tables without any issues ?