START_REDEF_TABLE Error ORA-42016

Leadership wants the DW to be open to apps 24x7x365, even while we are applying DDL changes. Sooooo, been playing and learning about DBMS_REDEFINITION to partition non-partitioned tables. That works just fine.

Now, i'm trying to change a partitioned table to use a different partition key. The main table is partitioned and has numerous partitions. The interim table has three new columns and the new partition key is one of the new columns. The interim table also has just one partition. I only pass in the schema, main table and interim table (leave all other parameters to defaults). CAN_REEF_TABLE on the main table completes successfully with no errors.

But, when I try to start_redef_table a partitioned table with an interim table, I get the below error:

ORA-42016: shape of interim table does not match specified column mapping
ORA-06512: at sys.dbms_redefinition, line 75
ORA-6512: at sys.dbms_redefinition, line 3554
ORA-06512: at line 1

So, I passed in column mappings for columns that exists in both the main and interim. There is no column name changes. But, get the same error. This makes me wonder if the problem is that the partition key changed.

Does anyone have experience in using REDEF to change partition keys? Is this possible with REDEF in 12.1?

Thanks - I always appreciate everyone's awesome advice and thoughts.

Thanks - Woody

--
http://www.freelists.org/webpage/oracle-l