Oracle Database Error Solutions & DBA Knowledge Base

Welcome to Oracle Database Error Solutions, a professional technical knowledge base dedicated to helping Oracle Database Administrators, Oracle E-Business Suite administrators, developers, and IT professionals troubleshoot Oracle Database and Oracle Linux issues with confidence.

This website provides practical, real-world troubleshooting guides based on hands-on Oracle administration experience. You'll find detailed solutions for Oracle Database errors, RMAN backup and recovery, Data Guard, ASM, RAC, Oracle Linux administration, Oracle E-Business Suite (EBS), cloning, performance tuning, patching, installation, and day-to-day DBA tasks.

Whether you're resolving ORA-27101, ORA-28040, ORA-01555, ORA-12154, ORA-01017, or other Oracle errors, our step-by-step articles are designed to save you time and help you solve problems efficiently.

EXP-00091 Exporting Questionable Statistics in Oracle - Complete Solution Guide

-

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

👉 Check our complete guide: Oracle Error Codes Guide

Author Box

About the Author

Rana Abdul Wahid is an experienced Oracle Database Administrator with expertise in Oracle Database Administration, Oracle Data Guard, RMAN Backup & Recovery, Oracle RAC, Oracle E-Business Suite, Performance Tuning, and High Availability Solutions.

Through this blog, he shares practical Oracle DBA solutions, troubleshooting guides, interview preparation resources, and production-tested best practices for database professionals worldwide.

Comments

Post a Comment