Re: Exporting and Importing Statistics

From: Hans Henrik Krohn <hhk_at_tips.dk>
Date: Mon, 26 Mar 2001 09:35:25 +0200
Message-ID: <99mrce$4gh$1@news.inet.tele.dk>

You'll need to look into DBMS_STATS, described in the "Supplied Packages Reference", to do what you want. Basically you can do something like this example concering statistics for a table called TRANSACTIONS:

• create statistics table in my own schema: execute sys.dbms_stats.create_stat_table (user, 'STATTAB');
• export statistic information to this table: execute sys.dbms_stats.export_table_stats (user, 'TRANSACTIONS', null', 'STATTAB');
• you can then export this STATTAB table, import it elsewhere, and insert the statistics into the system views: execute sys.dbms_stats.import_table_stats (user, 'TRANSACTIONS', null, 'STATTAB');

Regards, Hans Henrik Krohn

"Myron Wintonyk" <Myron.Wintonyk_at_UAlberta.ca> skrev i en meddelelse news:99hg4t$k$1_at_kraken.itc.gu.edu.au...
> I'm trying to import statistics from one db into another. However, the
> documentation is rather vauge in this area. I can't get it to work.
 Here's
> what I've tried:
>
> exp ... STATISTICS = NONE
> imp ... RECALCULATE_STATISTICS=Y ANALYZE=N
>
> Given that I was desperate, I tried every combination of these paraeters
 as
> well.
> STATISTICS=(COMPUTE,NONE) I didn't try ESTIMATE.
> RECALCULATE_STATISTICS=(Y,N)
> ANALYZE=(Y,N)
>
> Has anyone done this successfully and can give me a hint?
>
> Thanks ...
>
>
Received on Mon Mar 26 2001 - 01:35:25 CST