My Oracle Support Banner

Demantra How to Use TABLE_REORG to Reorder MDP_MATRIX in Primary Key (PK) Order Action Plan Version 7.3.1.3 and Later. See 1085012.1 Prior to 7.3.1.3 (Doc ID 1528966.1)

Last updated on MAY 07, 2019

Applies to:

Oracle Demantra Demand Management - Version 7.3.1 and later
Information in this document applies to any platform.
To locate the SQL mentioned in this note, review the following:

Oracle database scripts location has been moved from the root directory of the installation to the software installation under the following location:

\Demand Planner\Database Objects\Oracle Server\admin

The new admin directory has the following scripts:

GRANT_HTTP_TO_DEMANTRA.sql
grant_table_reorg.log
grant_table_reorg.sql
revoke_table_reorg.log
revoke_table_reorg.sql
run_table_reorg.sql
sys_grants.sql
system_revokes.sql
UPDATE_PASSWORDS.sql

Goal

I would like a sample action plan to use the procedure table_reorg on the mdp_matrix table.

Demantra MDP_Matrix table reorg by Primary Key.  This is a non partitioned table.

Sample Action Plan to create partitions on Demantra Sales_data table.  This has been used recently and was successful.

USE at your own responsibility after careful study and adjustment to meet your needs.  This was produced to use in an 11gr2 RDBMS environment.    

**  We are working on a version that will be specific to MDP_MATRIX.

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
 The table reorganization can be setup to automatically run in version 7.3.1.5
 Demantra MDP_Matrix table reorg by Primary Key.

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