Fixing QUESTIONABLE STATISTICS
I've created a new database from an export of a test database, and noticed (too late) that in the export log of the test database that there are numerous errors: EXP-00091: Exporting questionable statistics.
I would like to clean this up in both databases. I tried using:
exec dbms_stats.gather_schema_stats( -
ownname => 'TEST', -
options => 'GATHER', -
estimate_percent => dbms_stats.auto_sample_size, -
method_opt => 'for all columns size repeat', -
degree => 34 -
but on my next export of the database, I still have the EXP-00091 error.
What is the correct command to recompute all statistics in a db?
Oracle 9i 22.214.171.124 on Windows Server 2003
while doing the export just say statistics=none
Doc ID: Note:204793.1
Subject: EXP-00091 While Taking Export
Content Type: TEXT/X-HTML
Creation Date: 24-JUL-2002
Last Revision Date: 11-OCT-2002
Oracle Server - Enterprise Edition 9.0.1
Oracle Server - Enterprise Edition 9.2.0
EXP-00091: Exporting questionable statistics.
In Oracle 9i by default export attempts to include statistics in the export.
In pre Oracle 9i versions statistics are not included unless it is specified.
Bug 1862413 EXPORT & DEFAULT FOR STATISTICS SHOULD BE PRE-9I COMPATIBLE
Note 159787.1 9i: Import STATISTICS=SAFE
a) If the statistics of a table are not required to include in export
take the export with parameter STATISTICS=NONE
$exp scott/tiger file=emp1.dmp tables=emp STATISTICS=NONE
b) In case, the statistics are need to be included can use STATISTICS=ESTIMATE or
COMPUTE (default is Estimate).
Click Here to Expand Forum to Full Width