Table_Reorg errors ORA-14133 at Step 3 of Doc 1528966.1

(Doc ID 1990433.1)

Last updated on MARCH 08, 2017

Applies to:

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

Goal

Customer is working on the table re-org process for MDP_MATRIX table and is following Doc ID 1528966.1 for the same. He is executing Step 3 as per the doc which is

Step 3:- Move the table MDP_MATRIX to MDP_MATRIX_DATA
alter session force parallel dml;

alter table MDP_MATRIX move MDP_MATRIX_DATA parallel 7;

alter table MDP_MATRIX parallel 3;


But this is erroring out as below
SQL> alter table MDP_MATRIX move MDP_MATRIX_DATA parallel 7;
alter table MDP_MATRIX move MDP_MATRIX_DATA parallel 7
  *

ERROR at line 1:
ORA-14133: ALTER TABLE MOVE cannot be combined with other operations
 

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