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

Comments

Post a Comment

Popular posts from this blog

APPS Login Failed with error HTTP 404

-
APPS Login Failed with error HTTP 404             Applies to:             Oracle Enterprise Linux – Version: 7             Oracle EBS R12.1             Description: Oracle EBS Login page going to fail with error “The webpage cannot be found HTTP 404”. I have restart the services but the problem is same. All services started successfully. Error Log shows the following: $ LOG_HOME/ora/10.1.3/j2ee/oacore/oacore_default_group_1/log.xml which reports: Internal error raised trying to instantiate web-application: html defined in web site OC4J 10g (10.1.3) Default Web Site. Error compiling :$COMMON_TOP/webapps/oacore/html: Error instantiating compiler: Web service artifact generation failed:java.lang.InstantiationException: IO Error reading WEB-INF/wsdl/wsr...
Read more

REP-0501 ORA-01017 unable to connect to the specified database

-
REP-0501 ORA-01017 unable to connect to the specified database Applies to:             Enterprise Linux Version 5.7             Database 11gR2             Oracle Forms/Reports 6i Description:             We have an in-house developed application on Oracle Form/Reports 6i with Oracle Database 9.2 32bit on Windows Server 2008 32bit. Application is working fine. I have assigned a task from my manager to upgrade the database and also migrate the database server on Linux. I have done all the activities successfully. After that, Application is working fine except reports. When I run any report from application the report engine log give me the following error: REP-0501: Unable to connect to the specified database. ORA-01017: invalid username/password...
Read more

How to Rebuild/Recreate Concurrent Manager

-
How to Rebuild/Recreate Concurrent Manager Applies to:             Oracle Applications – Version: 11.5.10.2 and above Description:             After cloning, concurrent manager unable to start successfully at 0 status. Solution:             Check the following solution on test environment before implement on production environment, rebuild concurrent manager using following steps: ·          Stop concurrent manager and wait to clear all processes of FNDLIBR or kill the processes ·          select * from fnd_concurrent_processes where process_status_code='A'; ·          update fnd_concurrent_processes set process_status_code='K' where process_status_code='A'; ·  ...
Read more