Rebuild_tables Errors For Partitioned Mdp_matrix (Doc ID 1294094.1)

Last updated on MARCH 08, 2017

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

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