DBMS_STATS Raises ORA-20001 Error Without An Associated Error Text (Doc ID 1464832.1)

Last updated on AUGUST 26, 2014

Applies to:

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

Symptoms

Running DBMS_STATS.GATHER_TABLE_STATS for some tables errors out with "ORA-20001:"

Please note that the ORA-20001 error as shown does not have an actual error text/message associated but is blank, e.g:


Not all tables reported the error and the same statement succeeded for some tables.

Cause

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