Re: Exporting and Importing table statistics

I have no experience with this, but I think the package DBSTATS allows you to export stats to a table and then import those stats back into the data dictionary. I think outline perserves a query plan but ignores the dd stats.

Chaim

Jared Still <jkstill_at_cybcon.com> on 05/25/2001 03:32:54 PM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Chaim Katz/Completions/Bombardier)

On Friday 25 May 2001 01:05, Saurabh Sharma wrote:
> i feel this is at the full database export level.
> once u export ur database, u can import it as it is into another database
> and it'll create allthe required definitions for u.
> the statistics are exported with the tablespace and table definitions.
>
> hope i'm sure. if not pls correct.

OK, not correct. Statistics are not exported, check the manual.

EXP will recalculate statistics, but doesn't export them. At least I can find no indication of it.

You can use Oracle's plan stability feature however via CREATE OUTLINE.

Jared

>
> saurabh
> ----- Original Message -----
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Sent: Friday, May 25, 2001 3:48 AM
>
> > Hi all,
> > According to the 8i utilities manual I should be able to export a tables'
> > statistics
> > from one database, then import those statistics into another database.
> > I have tried various combinations of export and import scripts but
> > nothing seems to
> > work. My table has none of the restrictions described in the utilities
> > manual that
> > would prevent the statistics from being exported and then imported.
> > Can this export/import of statistics be done at a single table level or
> > does it have
> > to be a full database export? If not at the table level can it be done at
> > the schema
> > level?
> >
> > Thanks everyone,
> > Gary Bonner
> > bonnergj_at_songs.sce.com
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author:
> > INET: bonnergj_at_songs.sce.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > 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.com
--
Author: Jared Still
  INET: jkstill_at_cybcon.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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.com
-- 
Author: 
  INET: Chaim.Katz_at_Completions.Bombardier.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).