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 9.2.0.4 on Windows Server 2003
THANKS