1. Microservices Architecture Documentation
  2. Prepare
  3. Prepare Databases
  4. Oracle
  5. Oracle: Supported Data Types, Objects, and Operations for DDL and DML
  6. Details of Support for Oracle Data Types and Objects
  7. Handling Special Data Types
  8. XML

XML

The following are tools for working with XML within Oracle GoldenGate constraints.

  • Although Extract does not support the capture of changes made to an XML schema, you may be able to evolve the schemas and then resume replication of them without the need for a resynchronization, see Supporting Changes to XML Schemas.

  • Extract captures XML from the redo log. For UPDATE operations on an XML document, only the changed portion of the XML is logged if it is stored as OBJECT RELATIONAL or BINARY. To force whole XML documents to be written to the trail when only the changed portion is logged, use the TRANLOGOPTIONS parameter with the FETCHPARTIALXML option in the Extract parameter file. When Extract receives partial XML content from the logmining server, it fetches the full XML document instead of processing the partial XML. Use this option when replicating to a non-Oracle target or in other conditions where the full XML image is required.