Symptom
Various functions that call Oracle supplied PL/SQL packages (e.g. DBMS_STATS) terminate with an ORA-20003 error. You encounter errors similar to:
Database error 20003 at EXE
> ORA-20003: Specified bug number (<number>) does not
> exist#ORA-06512: at "SYS.DBMS_STATS", line 14457#ORA-06512:
> at "SYS.DBMS_STATS", line 14477#ORA-06512: at line 1
or
'BEGIN DBMS_STATS.GATHER_TABLE_STATS (OWNNAME => '"<owner_name>"', TABNAME =>
'"<table_name>"', ESTIMATE_PERCENT => 1, METHOD_OPT => 'FOR ALL COLUMNS SIZE 1',
DEGREE => NULL, CASCADE => TRUE, NO_INVALIDATE => FALSE); END;'
ORA-20003: Specified bug number (9196440) does not exist
ORA-06512: at "SYS.DBMS_STATS", line 15181
ORA-06512: at "SYS.DBMS_STATS", line 15203
ORA-06512: at line 1
or
BR0301E SQL error -20003 in thread 4 at location stats_tab_collect-21,
[...]
BR0886E Collecting statistics failed for table SAPSR3.<TABLE_NAME>
Read more...
Environment
SAP Netweaver based products running on Oracle
Keywords
ORA-20003, 5099019, 9196440, brconnect, SQL error -20003, SYS.DBMS_REGISTRY_SYS, BR0301E, location stats_tab_collect-21 , KBA , BC-DB-ORA , Oracle , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview