ora 00091 questionable statistics export
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: ora 00091 questionable statistics export

  1. #1
    Join Date
    Sep 2001
    Posts
    200

    ora 00091 questionable statistics export

    hi,
    I run an export and get the ora below. I check the error facility and they say I could amongst other things chande the NCHARSET of the client. How do I do that?
    Thanks



    00091, 00000, "Exporting questionable statistics."
    *Cause: Export was able export statistics, but the statistics may not be usuable. The statistics are questionable because one or more of the following happened during export: a row error occurred, client character set or NCHARSET does not match with the server, a query clause was specified on export, only certain partitions or
    subpartitions were exported, or a fatal error occurred while processing a table.

    *Action: To export non-questionable statistics, change the client character set or NCHARSET to match the server, export with no query clause, export complete tables. If desired, import parameters can be supplied so that only non-questionable statistics will be imported, and all questionable statistics will be recalculated.
    Life is what is happening today while you were planning tomorrow.

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,021
    Are you using windows? Open the registry and go to HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/HOME0 and look at NLS_LANG and make sure that it, "AMERICAN_AMERICA.WE8ISO8859P1", matches up with the result of
    Code:
    SQL > select * 
    from V$NLS_PARAMETERS 
    where parameter='NLS_CHARACTERSET';
    
    PARAMETER               VALUE
    --------------------- -------------------
    NLS_CHARACTERSET      WE8ISO8859P1
    this space intentionally left blank

  3. #3
    Join Date
    May 2005
    Location
    AZ, USA
    Posts
    131
    if you don't want the message use statistics=NONE in the export

  4. #4
    Join Date
    Oct 2005
    Location
    Indianapolis
    Posts
    100
    Quote Originally Posted by dbtoo
    if you don't want the message use statistics=NONE in the export
    Doesn't that mean on import you will have NO stats, unless you recalc during the import?
    "False data can act only as a distraction. Therefore. I shall refuse to perceive you." - Bomb #20

  5. #5
    Join Date
    Sep 2001
    Posts
    200
    thanks y'alll
    Life is what is happening today while you were planning tomorrow.

  6. #6
    Join Date
    May 2005
    Location
    AZ, USA
    Posts
    131

    Thumbs up

    Quote Originally Posted by tomcat
    Doesn't that mean on import you will have NO stats, unless you recalc during the import?
    According to the documentation
    STATISTICS
    Default: ESTIMATE

    Specifies the type of database optimizer statistics to generate when the exported data is imported. Options are ESTIMATE, COMPUTE, and NONE. See the Import parameter STATISTICS and Importing Statistics.

    In some cases, Export will place the precalculated statistics in the export file as well as the ANALYZE statements to regenerate the statistics.

    However, the precalculated optimizer statistics will not be used at export time if a table has columns with system-generated names.

    The precalculated optimizer statistics are flagged as questionable at export time if:

    There are row errors while exporting
    The client character set or NCHAR character set does not match the server character set or NCHAR character set
    A QUERY clause is specified
    Only certain partitions or subpartitions are exported

    So, ndisang seemed to be chasing after an option that he may not have really wanted to do. Just an opinion. Exports are, in our case, only utilized to retrieve data that some user deleted or to refresh the data in very small databases (We never export/import our 'large' - relative term - databases.) ndisang will need to determine if having or generating the statistics for import is worth mucking around with character sets, etc. Just layin' out some options.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width