Oracle EXP-00091 Error When Export Database

When trying to do a Oracle database dump or export, be it full entire database export or a particular user or table export, the following message may appears right after status of exporting a table.

EXP-00091: Exporting questionable statistics.

The cause for this error is because statistics may not be useable although Export was able to export statistics. The statistics are questionable because one or more of the following happened during export:

• A row error occurred
• Client character set or NCHARSET (where you run the Export) does not match with the server (database character set)
• A query clause was specified on export, only certain partitions or subpartitions were exported
• A fatal error occurred while processing a table

The resolution is to export non-questionable statistics, change the client character set or NCHARSET to match the server, export with no query clause, or export complete tables.

Most commonly, the EXP-00091 happens when the character set of client where Exp is running is different from character set of Oracle database server.

To solve this issue, try setting the NLS_LANG environment variable at the OS level, prior to the export session, to match your database character set. Syntax as follow, change the character set to your database’s character set.

export NLS_LANG=WE8ISO8859P1

For easier way of resolution, export with option “STATISTICS=NONE”. Also, if you’re using Oracle 10g, use Oracle Date Pump’s expdp and impdp instead of instead of exp and imp to export and import the data.

It’s pretty safe to say that if EXP-00091 is the only error message, the export’s row data is without any problems. If desired, import parameters can be supplied so that only non-questionable statistics will be imported, and all questionable statistics will be recalculated.

At the beginning of Export, the charset of the database will be shown. Else, you will need to use “show parameter nls” in SQL*Plus to check what charset the Oracle database is using.

Related Articles

• IMP-00016 Required Character Set Conversion Not Supported Error when Import to Oracle Database
• Oracle Database Import Error 3113/3114
• Create, Add or Split Oracle Database Partition Fails with ORA-14080 Error
• Change Oracle Database User Password
• Oracle Database Link
• IMP-00013 Oracle Import Error
• How Drop Tablespace and Recover Oracle Database When Accidentally Delete Datafile
• ORA-00942 Table or View Does Not Exist Oracle Error
• View and Retrieve Oracle Database Link Details
• Oracle ORA-14074 Create or Add New Partition Fails Error

This entry was posted on Sunday, March 19th, 2006 at 12:26 am and is filed under Databases. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.