Articles tagged

13 July 2015
13 July 2015

Integrated DDL and DML with Encrypt using Oracle GoldenGate 12c

0
1
Introduction: Integrated Replicat is a feature unique to Oracle GoldenGate 12c, for Oracle Database versions starting from Oracle 11g (11.2.0.4) and Oracle 12c (12.1.0). Classic Capture Mode: The Oracle GoldenGate Extract process captures data changes from the Oracle redo log files or archive log files on the source database system. Integrated Capture Mode: Oracle GoldenGate Extract process works directly wit… Read more
30 December 2014
30 December 2014

Archiving Hierarchical, Deleted Transactions Using XML

When you delete a business transaction from the database, there are times when you might want to keep a record of the data for posterity. This can become somewhat complicated if the transaction you need to delete is in a table that is the parent of a deeply nested hierarchy of dependent tables based on the foreign key relationships. In this article, Dwain Camps looks at a tidy means of doing just that.… Read more