Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Use exp exported EXP-00091 error     - Process safety monitoring and protection under the Linux operating system (Linux)

- Linux VMware virtual machine after the cloning of the card can not start to solve (Linux)

- Write perfect printf (Programming)

- Cool Android realization SVG animation (Programming)

- Ease of use "Explain Shell" script to understand Shell command (Linux)

- Fedora 22 Server how to upgrade to Fedora 23 Beta Server (Linux)

- Let Ubuntu 14.04 Save screen luminance value (Linux)

- Stucts2 values on the page and how the attribute values corresponding to the Action (Programming)

- CentOS Set the Mono environment variable (Server)

- 20+ Best Practices article MySQL Performance Optimization (Database)

- How to disable UEFI to install Linux on Win8 (Linux)

- Windows using SSH management Ubuntu (Linux)

- Construction of Android and iOS apps use Jenkins Automation (Programming)

- Hadoop virtualization performance comparison and tuning experience (Server)

- Ubuntu 14.04 LTS next upgrade gcc to gcc-4.9, gcc-5 version (Linux)

- Oracle view object space usage show_space (Database)

- MongoDB 3.2 to upgrade from 3.0.7 (Database)

- Hadoop 2.0 Detailed Configuration Tutorial (Server)

- iOS9 new feature - stacked view UIStackView (Programming)

- lolcat: an output terminal rainbow effects in the Linux command-line tool (Linux)

 
         
  Use exp exported EXP-00091 error
     
  Add Date : 2017-08-31      
         
         
         
  Use the following command to perform the export:

exp user / pwd @ db file = / home / a.dmp log = / home / a.log

Output the following information, which contains some of the error messages EXP-00091:

.. Exporting table T 0 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.

But guided by the dump file can be used to import.

Look for the official introduction of the EXP-00091:

EXP-00091: 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.

Roughly meaning the export process, because the character set or the client and server side NCHARSET parameters inconsistent, resulting in some of the statistical information is not available. The solution is not a problem you can export statistics, or change the character set or the client NCHARSET parameters.

Experiment:
plan 1:
Query server-side character set:

SQL> select userenv ( 'language') from dual; USERENV ( 'LANGUAGE')

-------------------------------------------------- -----

AMERICAN_AMERICA.AL32UTF8

Set the client character set:

[Oracle @ Node] ~> export NLS_LANG = AMERICAN_AMERICA.AL32UTF8

The export command:

[Oracle @ Node] ~> exp user / pwd @ db file = / home / a.dmp log = / home / a.log

.. Exporting table T 0 rows exported

No longer being given.

Scenario 2:

exp user / pwd @ db file = / home / a.dmp log = / home / a.log statistics = none

Statistics statistics information field is set to none.
The export command:

[Oracle @ Node] ~> exp user / pwd @ db file = / home / a.dmp log = / home / a.log

.. Exporting table T 0 rows exported

No longer being given. But in this way corresponds to those who did not export character set is inconsistent error statistics, this part will not have to import natural statistical information, if needed, you can only re-gather the statistics.

So for this exp EXP-00091 error message, you can have both ways workaround, but certainly still recommend Option 1, the most comprehensive export information.
     
         
         
         
  More:      
 
- How to allow users to access only a specific database (MSSQL) (Database)
- Ubuntu uses the / etc / profile file to configure the JAVA environment variable (Linux)
- C ++ inline functions (Programming)
- Oracle 11g RMAN virtual private directory (Database)
- Oracle 10g after the failure to start the upgrade (Oracle instance terminated. Disconnection forced) (Database)
- MariaDB database storage path modify configuration issues (Database)
- Understanding the type in C ++ bitset (Programming)
- GNU / Linux enable Intel Rapid Start (Linux)
- Linux ls command (Linux)
- Linux System Getting Started Learning: On Linux how to convert text files to PDF (Linux)
- Android application simulates the phone keypad (Programming)
- The lambda expression Java8 (constructor references) (Programming)
- LVM management reduces swap partition space to the root partition (Linux)
- C ++: Postmodern systems programming language (Programming)
- PostgreSQL log classification and management (Database)
- Examples of safety testing system notes for RedHat Linux (Linux)
- Some safety precautions of Linux servers (Linux)
- A custom implementation of the Android sidebar (Programming)
- OpenJDK7 source compiler installation on CentOS 6.5 (Linux)
- Empty password Linux operating system (Linux)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.