RE: Copying stats between/amongst schemas

From: Orr, Steve <sorr_at_rightnow.com>
Date: Tue, 02 Dec 2003 17:19:25 -0800
Message-ID: <F001.005D8722.20031202171925@fatcity.com>

Oh... So you exec dbms_stats.export_schema_stats(...) while logged in under the source schema owner user then you exec dbms_stats.import_schema_stats(...) while logged in under the target schema owner user? I wanted to do this under a DBA account which doesn't own anything.

alter session set current_schema=Doh
/

-----Original Message-----
Paul Baumgartel
Sent: Tuesday, December 02, 2003 5:34 PM To: Multiple recipients of list ORACLE-L

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

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

Received on Tue Dec 02 2003 - 19:19:25 CST