using dbms_redefinition.copy_table_dependents to copy statistics

From: Li Li <litanli_at_gmail.com>
Date: Thu, 3 May 2012 13:17:44 -0500
Message-ID: <CAN-mCbN+hGtLoUL1fVBSvh=6LretE+CUb7etWDcbYg+Q3Uwapw_at_mail.gmail.com>



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
--

http://www.freelists.org/webpage/oracle-l Received on Thu May 03 2012 - 13:17:44 CDT

Original text of this message