Re: using dbms_redefinition.copy_table_dependents to copy statistics

From: Sriram Kumar <k.sriramkumar_at_gmail.com>
Date: Mon, 7 May 2012 18:42:44 +0530
Message-ID: <CAEq4C0c7iyjPJWJwah4_4b=5nLKpu6fpMNYznvcjAnVYNy7UBg_at_mail.gmail.com>



Hi Li,
copy_statistics argument in 11.1 defaults to false. you will have to explicitly make it true

http://docs.oracle.com/cd/B28359_01/appdev.111/b28419/d_redefi.htm

Best Regards

Sriram Kumar

On Thu, May 3, 2012 at 11:47 PM, Li Li <litanli_at_gmail.com> wrote:

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

--
http://www.freelists.org/webpage/oracle-l
Received on Mon May 07 2012 - 08:12:44 CDT

Original text of this message