RE: exporting / importing Object Stats?

Alex, Wolfgang, List

WOW. Any info on the following, if possible?

We have a Table which is RE-Created Daily with respective Partition names changing daily Date-wise i.e. <Partition Name>_<Day of Month>.

Can Statistics gathered Once into STATTAB be SQL Updated Suitably for Changed Partition names & IMPORTED thereafter Daily? If so which fields/Columns?

desc <STATTAB Name>

 Name                                      Null?    Type
 ----------------------------------------- --------
----------------------------
 STATID                                             VARCHAR2(30)
 TYPE                                               CHAR(1)
 VERSION                                            NUMBER
 FLAGS                                              NUMBER
 C1                                                 VARCHAR2(30)
 C2                                                 VARCHAR2(30)
 C3                                                 VARCHAR2(30)
 C4                                                 VARCHAR2(30)
 C5                                                 VARCHAR2(30)
 N1                                                 NUMBER
 N2                                                 NUMBER
 N3                                                 NUMBER
 N4                                                 NUMBER
 N5                                                 NUMBER
 N6                                                 NUMBER
 N7                                                 NUMBER
 N8                                                 NUMBER
 N9                                                 NUMBER
 N10                                                NUMBER
 N11                                                NUMBER
 N12                                                NUMBER
 D1                                                 DATE
 R1                                                 RAW(32)
 R2                                                 RAW(32)
 CH1                                                VARCHAR2(1000)

Thanks indeed for responding

-----Original Message-----
From: Alex Gorbachev [mailto:gorbyx_at_gmail.com] Sent: Saturday, October 15, 2005 4:00 AM To: breitliw_at_centrexcc.com
Cc: VIVEK_SHARMA; Oracle-L
Subject: Re: exporting / importing Object Stats?

In fact, you can even update stats table and set statistics for different users/tables/indexes. For example, I often update username (column C5 if I remeber well) to "clone" statistic to another schema. This can also be used for changed names of system generated columns.

2005/10/13, Wolfgang Breitling <breitliw_at_centrexcc.com>:
> 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',STATOW N=>'TBAADM',CASCADE=>TRUE);

• 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*** -- http://www.freelists.org/webpage/oracle-l