My Oracle Support Banner

How to Truncate the Tables of the External Database Used with the ODI XML Driver ? (Doc ID 867944.1)

Last updated on JUNE 16, 2022

Applies to:

Oracle Data Integrator - Version 10.1.3.5.0 and later
Information in this document applies to any platform.



Goal

Is it possible to truncate the RDBMS tables set up using the External Database feature of the ODI XML Driver after having loaded the XML file and then using the Datastores as Sources for Integration Interfaces?

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
 1. Set up the XML Data Server URL to use the External database feature
 2) Load the data from the XML File using the SYNCHRONIZE command
 3) Truncate the RDBMS tables
 4) Replace the XML file
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.