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 21, 2023
Applies to:
Oracle Demantra Demand Management - Version 7.3.1 and laterInformation 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:
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. |
| Table_Reorg Examples |