Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> exporting questionable statistics

exporting questionable statistics

From: Randy Harris <please_at_send.no.spam>
Date: Mon, 26 Jun 2006 03:42:41 GMT
Message-ID: <RIIng.28948$VE1.13160@newssvr14.news.prodigy.com>


I've just migrated a database from one server to another (8i on HP-UX to 9i on Solaris). I used exp and imp to move the data over.

Now when I exp from the new database I get many warnings about "questionable statistics". I thought that running DBMS_STATS.GATHER_DATABASE_STATS and DBMS_STATS.GATHER_SYSTEM_STATS would update the statistics and stop the error messages. They didn't.

I have two questions:

  1. What more do I need to do to update the statistics?
  2. Should I have exp'd without statistics in the first place to avoid bringing the "questionable statistics" into the new database?

Thanks for any help you can provide.

-- 
Randy Harris
tech at promail dot com
I'm pretty sure I know everything that I can remember.
Received on Sun Jun 25 2006 - 22:42:41 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US