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:

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.

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.

Solution

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