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 JUNE 23, 2017

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

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