My Oracle Support Banner

Demantra Non Invasive Partial Schema Export Utility Extracting Partial Schema Dumps for Analysis (Doc ID 1448266.1)

Last updated on MAY 19, 2023

Applies to:

Oracle Demantra Real-Time Sales and Operations Planning - Version 7.3.0 and later
Oracle Demantra Advanced Forecasting and Demand Modeling - Version 7.3.0 and later
Oracle Demantra Demand Management - Version 7.3.0 and later
Oracle Demantra Predictive Trade Planning - Version 7.3.0 and later
Oracle Demantra Deduction and Settlement Management - Version 7.3.0 and later
Information in this document applies to any platform.


Hello!  Updates to the Demantra TABLE_REORG Tool, Patch 13930627, are Available.  This is an updated re-release of the generic Partial Schema Exporter Tool.  The generic patch is for 7.3.1.x and 12.2.x.

Current build of this patch is Build 12.

Some fixes for this patch are included in demantra version 12.2.3 and upper versions. However, if any issue is encountered, please review Readme of the Patch and apply.

Installation instruction as per Readme file:




This process will allow you to extract a smaller footprint of data to transfer to Oracle Support/Development for analysis.  This was developed for ease of use in debugging Demantra issues plus this procedure enhances the security of the data dump process by allowing the customer to extract a piece of their Demantra schema.

In addition, all of the metadata is exported.  These dumps can then be imported into another schema.  The new schema will act just like a normal Demantra system, with only part of the original schema's data.

Why is it needed?
Diagnosing and fixing problems in very large customer schemas can be problematic.  The dump file may take a long time to be generated, ftp-ed, and
imported.  Also, only certain servers have large enough storage capacity to handle large schemas.  Additionally, a customer may be wary of providing all
of their data to development.  The partial schema export tool answers these problems.

How does it work?
The tool is a Demantra database package, called DATAPUMP.  It is submitted from an Oracle SQL connection.


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
 Please see patch 13930627, DEMANTRA PARTIAL SCHEMA EXPORT TOOL for the latest updates.
 Please click on  the note below to access the instructions in PDF format.

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