Golden Gate Replication aborts after ZDU Upgrade | UC_XML_TEST

book

Article ID: 220351

calendar_today

Updated On:

Products

CA Automic One Automation

Issue/Introduction

The DBA found the following objects was dropped , extract was abended on UC_XML_TEST. As it was not available on both and source so excluded UC_XML_TEST table from parameter file. What this is table and why it is used since it seems like so it looks TEST tables?

Environment

Release : 12.3

Component : AUTOMATION ENGINE

Resolution

UC_XML_TEST is a test table. It is created so that some basic functionalities can be tested such as dropping the table. 

It can be found in \Utility\db\oracle\12.3\check_privileges.sql

Additional Information

CREATE TABLE UC_Xml_Test(installcheck XMLTYPE);
INSERT INTO UC_Xml_Test VALUES ('<a>b</a>');
SELECT extractValue(installcheck, '/a/text()') FROM UC_Xml_Test;