Details
-
Suggestion
-
Resolution: Unresolved
-
None
-
None
-
7
-
Description
In our company we use Golden Gate to replicate databases. Our DBAs found following issues which prevent Golden Gate from replicating schema used by Stash:
1. Indexes and constraints with system generated names are not supported
CONSTRAINT_TYPE TABLE_NAME
------------------------------- ------------------------------
P AO_CFE8FA_BUILD_STATUS
P AO_FB71B4_PUBLIC_KEY
P AO_6978BB_RESTRICTED_REF
P AO_6978BB_PERMITTED_ENTITY
U WEIGHTED_PERMISSION
P PLUGIN_SETTING
P - Primary Key
U - Unique Key
Solution: Primary/Unique keys and indexes assigned to them should be named
2. Tables With No Primary Key or Unique Index
Table Rows
------------------------ --------
CS_ATTRIBUTE 906
HIBERNATE_UNIQUE_KEY 1
HT_STA_PR_ACTIVITY
ID_SEQUENCE 14
Solution: Primary or Unique keys should be created for those tables.
Attachments
Issue Links
- is related to
-
BSERV-2699 Cannot initialize Oracle schema
- Closed
- relates to
-
BSERV-4964 Support MySQL Replication using Global Transaction IDs
- Closed