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 -> Re: exporting questionable statistics

Re: exporting questionable statistics

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 26 Jun 2006 06:58:19 +0200
Message-ID: <1aqu92558u8mgq8mec62l4opo7v80ug9q8@4ax.com>


On Mon, 26 Jun 2006 03:42:41 GMT, Randy Harris <please_at_send.no.spam> wrote:

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

IIRC this error is a result of incorrect NLS_LANG settting upon export.

--
Sybrand Bakker, Senior Oracle DBA
Received on Sun Jun 25 2006 - 23:58:19 CDT

Original text of this message

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