My Oracle Support Banner

Rebuild_tables Errors For Partitioned Mdp_matrix (Doc ID 1294094.1)

Last updated on MARCH 26, 2019

Applies to:

Oracle Demantra Demand Management - Version 7.2.0.2 and later
Information in this document applies to any platform.

Symptoms


PROBLEM
-------------
In Demantra version 7.2.0.2:

MDP_MATRIX table is partioned.
When
exec REBUILD_TABLES('mdp_matrix');
is executed, then the following error is displayed:
"
ERROR at line 1:
ORA-20002: ORA-14511: cannot perform operation on a partitioned object
Error in PROCEDURE REBUILD_TABLES line 132
dynamic_ddl( 'ALTER TABLE mdp_matrix MOVE TABLESPACE NOLOGGING ')
ORA-06512: at "DEMANTRA.SEND_ERR_MESSAGE", line 21
ORA-06512: at "DEMANTRA.DYNAMIC_DDL", line 22
ORA-06512: at "DEMANTRA.REBUILD_TABLES", line 132
ORA-06512: at line 1
"


STEPS
--------
Partition MDP_MATRIX table
Run exec REBUILD_TABLES('mdp_matrix');


Cause

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
Symptoms
Cause
Solution
References


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