Gathering Statistics with DBMS_STATS Fails With: 'ORA-20003: Specified Bug Number (%s) Does Not Exist' Where the Bug number Reported is 5099019 or 16470836 (Doc ID 1180514.1)

Last updated on JUNE 12, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 and later
Information in this document applies to any platform.

Symptoms

Executing DBMS_STATS fails with either of the following error messages:

SQL> set serveroutput on
SQL> exec dbms_stats.gather_table_stats(ownname=> 'SCHEMA',tabname=>
'TABLE_NAME', degree=>4 , cascade=>TRUE, estimate_percent=>25);

BEGIN dbms_stats.gather_table_stats(ownname=> 'SCHEMA',tabname=> 'TABLE_NAME', degree=>4 , cascade=>TRUE, estimate_percent=>25); END;
*
ERROR at line 1:
ORA-20003: Specified bug number (5099019) does not exist
ORA-06512: at "SYS.DBMS_STATS", line 13474
ORA-06512: at "SYS.DBMS_STATS", line 13494
ORA-06512: at line 1

or

SQL error -20003 at location stats_tab_collect-21, SQL statement:
'BEGIN DBMS_STATS.GATHER_TABLE_STATS (OWNNAME => '"SCHEM"', TABNAME => '"TABLE_NAME"', ESTIMATE_PERCENT => NULL, METHOD_OPT => 'FOR ALL COLUMNS SIZE 1', DEGREE => NULL, CASCADE => TRUE, NO_INVALIDATE => FALSE); END;'
ORA-20003: Specified bug number (16470836) does not exist
ORA-06512: at "SYS.DBMS_STATS", line 24301
ORA-06512: at "SYS.DBMS_STATS", line 24352
ORA-06512: at line 1

Changes

An upgrade may have occurred, but this is not necessary to trigger this issue.

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