Suppose you want to modify partitioning scheme of certain tables in a live database. How can you do that? | Oracle DBA

You can use the dbms_redefinition package to modify partitioning scheme of certain tables in a live database.