Tuesday, June 11, 2019

EXP-00091 Exporting Questionable Statistics


EXP-00091 Exporting Questionable Statistics

Applies to:
            Oracle Enterprise Linux – Version: 7
            Oracle Database 11.2.0.4

Description:
After upgrade Oracle Database from 11.2.0.1.0 to 11.2.0.4.0, when export database user dump face the following error:
“EXP-00091 Exporting questionable statistics”

Solution:
            I have found that the error occur when try to export table data with its related optimizer statistics. To fix the error run export with parameter “statistics=none”:

exp scott/tiger file=exp_scott.dmp statistics=none


           

Your comments, especially which will help us improve the functionality, will be greatly appreciatedJ

ORA-00001: Unique Constraint Violated – Complete Guide

ORA-00001: Unique Constraint Violated in Oracle – Complete Fix Guide (Step-by-Step) The ORA-00001: unique constraint violated error is one...

Contact / Feedback Form

Name

Email *

Message *