Steve, I've done this: first export the source schema's stats from the
dictionary into a user table, then import from that user table into the
dictionary for the target schema. (Use CREATE_STAT_TABLE to create the
user table.)
Paul Baumgartel
- "Orr, Steve" <sorr_at_rightnow.com> wrote:
> I see the schema import/export procedures in the package but they
> just import/export the stats for a particular schema into or out of
> the dictionary. There's no procedure to copy stats from one schema to
> another within the dictionary... At least that's my understanding
> from reading the docs.
>
>
> -----Original Message-----
> Sent: Tuesday, December 02, 2003 4:24 PM
> To: Multiple recipients of list ORACLE-L
>
>
> dbms_stats is the only sanctioned way to do it.
>
> Orr, Steve wrote:
>
> > 1 database instance, 2 nearly identical schemas. What's the best
> > sanctioned way to copy stats, (including histograms), from one
> schema
> > to another?
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
> INET: mln_at_miracleas.dk
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing)
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Orr, Steve
> INET: sorr_at_rightnow.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Paul Baumgartel
INET: treegarden_at_yahoo.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Tue Dec 02 2003 - 18:34:27 CST
