Message-ID: <F001.005D871F.20031202163427@fatcity.com>
Date: Tue, 02 Dec 2003 16:34:27 -0800
To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
Sender: ml-errors@fatcity.com
Reply-To: ORACLE-L@fatcity.com
Errors-To: ML-ERRORS@fatcity.com
From: Paul Baumgartel <treegarden@yahoo.com>
Subject: RE: Copying stats between/amongst schemas
Organization: Fat City Network Services, San Diego, California
Precedence: bulk
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

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@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@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@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@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@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@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@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).