I am testing converting a partitioned table (table controlled) to a UTS and changing the indexes not partitioned to be partitioned mostly for parallel processing and being able to reorg at the partition level. The table has 16 partitions.
The existing clustering unique index which is partitioned has these columns
One existing non-partitioned index is defined as unique on column ACCT_NBR. When I attempt to create it as a unique partitioned index I get the -628. I read the manual explanation and it didn't quite make sense.
After some thought I believe what I need to do is drop the clustering unique index (client_nbr and acct_nbr) and create it as the clustering index and the other index create it as unique on acct_nbr. That would make sense which would make it such that no multiple clint_nbr's would have the same acct_nbr.
Does this make sense?