Dear group, Have you ever had a need to move a table into a partitioned or subpartitioned table, while your table can not be off line any minutes? Or any other need to redesign your table on a 24/7 database?
Oracle 9i has a package DBMS_REDEFINITION, but it can not work on 8i, and it is far from automatic. I wrote a perl scripte that will do all DBMS_REDEFINITION do, but it is much more automatic. It has been tested, but it is so mission critical, I am now sending it to you guy to see whether there is some bugs, or some improvements, comments. You are more than welcome to distribute it as you wish. Thanks chunning
table_redef.pl
Description: table_redef.pl
