We were trying to upgrade from 10g to 11g. After running an export of the schemas from the 10g database, we installed Oracle 11g and tried to import the schema back into the new database (11g). Then we ran into error EXP-00091 Exporting questionable statistics.
Cause:
The "EXP-00091 Exporting questionable statistics" error occurs when a DBA tries to export table data with its related optimizer statistics, and Oracle cannot verify the currency of these statistics. Please note that Oracle has to verify statistics whenever it does an export; otherwise this error will be thrown.
DBMS_STATS controls this process. You can always skip and let Oracle handle the statistics after the data has been imported into the new database. This process is known as statistics recalculation.
Solution:
Run 'exp' with "statistics=none" option to skip the statistics collection and bypass the error. For instance:
exp scott/tiger file=scott.imp log=scott.log statistics=none
This will create a dumpfile with the name "scott.imp" and the statistics will be ignored.
No comments:
Post a Comment