Demantra How to Use TABLE_REORG to Reorder MDP_MATRIX in Primary Key (PK) Order Action Plan Version 18.104.22.168 and Later. See 1085012.1 Prior to 22.214.171.124
(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:
The new admin directory has the following scripts:
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.
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
|The table reorganization can be setup to automatically run in version 126.96.36.199|
|Demantra MDP_Matrix table reorg by Primary Key.|