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

Last updated on JULY 27, 2017

Applies to:

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

Goal

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.


This is build 10 of the patch.

The fixes for this patch are included in demantra version 12.2.3 and upper versions.

 

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.

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms