DBMS_REDEFINITION to redefine all the partitions of a table
Hi there.
I've found Doc ID 795893.1 which explains how to redefine a single partition of a table.
In my case, we need to redefine all the partitions of a table, including local and global indexes. And we need to do it online.
So, my simple question here is: Does anyone have an example of how to do it?
We need to perform it over 103 partitions on a pre-production environment. So we need to know if the method on that Doc ID just needs to be replicated all those times