ORA-20002 on Importing Statistics using DBMS_STATS Procedures

(Doc ID 740345.1)

Last updated on OCTOBER 08, 2017

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 10.2 to 11.2]
Information in this document applies to any platform.


When the database versions for exporting and importing statistics are not the same, an ORA-20002 may be returned depending on versions used for the export and import.
The text of the error message will be different depending on whether the import is done into a higher or lower version.

Importing from Lower Version of Oracle into Higher Version

The following error message is displayed:



Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms