Re: exporting questionable statistics

From: Vladimir M. Zakharychev <vladimir.zakharychev_at_gmail.com>
Date: 27 Jun 2006 10:48:16 -0700
Message-ID: <1151430496.146793.38740@75g2000cwc.googlegroups.com>

Sybrand Bakker wrote:
> 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

Your memory serves you well, as usual. :) More specifically, the database charset and charset specified in NLS_LANG on host where export utility runs must match, otherwise charset conversion is possible and statistics on character columns become questionable.

Regards,

Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm) http://www.dynamicpsp.com Received on Tue Jun 27 2006 - 12:48:16 CDT