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

How to Configure Tiger VNC Server on Linux 7

-
How to Configure Tiger VNC Server on Linux 7 Applies to:             Oracle Enterprise Linux – Version: 7 Description:             After successful installation of Oracle Linux 7, I need to configure VNC for remote access. Solution:             To configure Tiger VNC server on Oracle Linux 7 follow the simple steps:             To check the required rpm’s: [root@testora ~]# rpm –qa |grep tigervnc Install tigervnc-server [root@testora ~]# yum install tigervnc-server –y               To create a user for VNC: [root@testora ~]# adduser vncuser [root@testora ~]# passwd vncuser   [root@testora ~]# su - vncuser [vncuser@testora ~]$ vncpasswd Password: Verify: [vncuser@tes...
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