Re: exporting / importing Object Stats?

Yes, as long as the schema, table, column, and index names are the same. Watch out for system generated column names which are almost certainly different between databases (unles one is a clone of the other).

VIVEK_SHARMA wrote:
>
>
> A basic Qs
>
>
>
> After exporting a Table’s “statistics” & will it’s import into another
> Database containing the Same Table name & field Structure but Different
> Object ID be successful?
>
>
>
> e.g. When using following command for EMP Table
>
> Dbms_stats.IMPORT_TABLE_STATS(‘TBAADM’,’EMP’,STATTAB=>’SAVESTATS’,STATOWN=>’TBAADM’,CASCADE=>TRUE);
>
>
>
>
>
> Thanks
>
>
>
> **************** CAUTION - Disclaimer *****************
> This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended
> solely for the use of the addressee(s). If you are not the intended
> recipient, please notify the sender by e-mail and delete the original
> message. Further, you are not to copy, disclose, or distribute this
> e-mail or its contents to any other person and any such actions are
> unlawful. This e-mail may contain viruses. Infosys has taken every
> reasonable precaution to minimize this risk, but is not liable for any
> damage you may sustain as a result of any virus in this e-mail. You
> should carry out your own virus checks before opening the e-mail or
> attachment. Infosys reserves the right to monitor and review the content
> of all messages sent to or from this e-mail address. Messages sent to or
> from this e-mail address may be stored on the Infosys e-mail system.
> ***INFOSYS******** End of Disclaimer ********INFOSYS***
>

-- 
Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com
--
http://www.freelists.org/webpage/oracle-l