Discussion:
START_REDEF_TABLE Error ORA-42016
Woody McKay
2018-08-29 21:53:07 UTC
Permalink
Hi all - Oracle 12.1.0.2 on Linux

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

Loading...