参考杨大师的：http://space.itpub.net/4227/viewspace-168447
10g在dbms_redefinition包中增加了COPY_TABLE_DEPENDENTS过程，用于索引、约束、触发器、统计信息和授权的表的在线重定义
实验过程：
SQL> select table_name,index_name,column_name from user_ind_columns where table_name='FUNCTIONS_INFO';
TABLE_NAME INDEX_NAME COLUMN_NAME
------------------------- ------------------------------ ------------------------------
FUNCTIONS_INFO FUNCINFO_GAMEKID_IDX GAME_KIND_ID
FUNCTIONS_INFO SYS_C007875 FUNCTION_ID
SQL> create table functions_info_m as select * from functions_info where 1=0;
SQL> exec dbms_redefinition.can_redef_table('WEP','FUNCTIONS_INFO');
PL/SQL procedure successfully completed.
SQL> exec dbms_redefinition.start_redef_table('WEP','FUNCTIONS_INFO','FUNCTIONS_INFO_M');
PL/SQL procedure successfully completed.
SQL> var v_num number
SQL> exec dbms_redefinition.copy_table_dependents('WEP','FUNCTIONS_INFO','FUNCTIONS_INFO_M',dbms_redefinition.cons_orig_params,true,true,true,true,:v_num,true);
PL/SQL procedure successfully completed.
SQL> exec dbms_redefinition.finish_redef_table('WEP','FUNCTIONS_INFO','FUNCTIONS_INFO_M');
PL/SQL procedure successfully completed.
SQL> select table_name,index_name,column_name from user_ind_columns where table_name='FUNCTIONS_INFO';
TABLE_NAME INDEX_NAME COLUMN_NAME
------------------------- ------------------------------ ------------------------------
FUNCTIONS_INFO SYS_C007875 FUNCTION_ID
FUNCTIONS_INFO FUNCINFO_GAMEKID_IDX GAME_KIND_ID
SQL> select table_name,index_name,column_name from user_ind_columns where table_name='FUNCTIONS_INFO_M';
TABLE_NAME INDEX_NAME COLUMN_NAME
------------------------- ------------------------------ ------------------------------
FUNCTIONS_INFO_M TMP$$_FUNCINFO_GAMEKID_IDX0 GAME_KIND_ID
FUNCTIONS_INFO_M TMP$$_SYS_C0078750 FUNCTION_ID
这样重定义后的索引名也与原来同名了，完整的完成了一个table的在线重定义。
