Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> exporting questionable statistics
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:
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