My Oracle Support Banner

Alternatives to DB.XML to Extract Data Sets Greater than 5 MB (Doc ID 2774178.1)

Last updated on MAY 13, 2021

Applies to:

Oracle Transportation Management Cloud Service - Version 21.1 and later
Information in this document applies to any platform.

Goal

Previously you used DB.XML to extract large data sets. After the 21A release DB.XML is limited to XML size of 5MB. 

For now you are opting out of the optional property DBXML EXPORT LIMIT but this limit will become mandatory in release 21C. What options are available to you for this data extraction post 21C?

Support's general recommendation is to break the extract of the data into smaller chunks but you need a way to extract chunks of data larger than 5 MB.

In <Note 2566583.1> Extracting Data From OTM/GTM Cloud you have these options:

 

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
References


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