using dbms_redefinition.copy_table_dependents to copy statistics

  • From: Li Li <litanli@xxxxxxxxx>
  • To: oracle-l <Oracle-L@xxxxxxxxxxxxx>
  • Date: Thu, 3 May 2012 13:17:44 -0500

Hi List,

I am wondering if anyone on the list has used
dbms_redefinition.copy_table_dependents to copy statistics
successfully? In my test to partition an existing table using
dbms_redefinition, I tried to use
dbms_redefinition.copy_table_dependents with parameter copy_statistics
set to TRUE, but it didn't copy the statistics over. Any suggestions
or comments?

Version: 11.1.0.7

Thanks,
-Li
--
//www.freelists.org/webpage/oracle-l


Other related posts: