2610624 - ORA-20000 DBMS_STATS.GATHER_TABLE_STATS | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2610624 - ORA-20000 DBMS_STATS.GATHER_TABLE_STATS

Symptom

SAP work process trace shows following error:

C BEGIN DBMS_STATS.GATHER_TABLE_STATS (OWNNAME => :A0, TABNAME => :A1, ESTIMATE_PERCENT => 10, METHOD_\
C OPT => 'FOR ALL COLUMNS SIZE 1', DEGREE => NULL, CASCADE => TRUE, NO_INVALIDATE => FALSE); END;;
C head_p=9fffffffffff6eb0, cid=0: dbsl err=99=DBSL_ERR_DB-> dbds err=1=DS_SQLERR,dbdsoci.c:864
C *** ERROR => ^^ Ds_exec(cid=0) -> err=1=DS_SQLERR
[dbdsoci.c 946]
C {root-id=0017A477A0501ED886D66E7F7CEA180E}_{conn-id=00000000000000000000000000000000}_0
B ***LOG BY2=> sql error 20000 performing EXE [dbds 672]
B ***LOG BY0=> ORA-20000: Unable to analyze TABLE "SAPSR3"."CCSELTAB", insufficient privileges or does not exist
ORA-06512: at "SYS.DBMS_STATS", line 34959
ORA-06512: at line 1 [dbds 672]

This can also be reproduced via sqlplus with sys user:

sqlplus /as sysdba
BEGIN
DBMS_STATS.GATHER_TABLE_STATS (OWNNAME => 'SAPSR3', TABNAME => 'CCSELTAB', ESTIMATE_PERCENT => 10, METHOD_OPT => 'FOR ALL COLUMNS SIZE 1', DEGREE => NULL, CASCADE => TRUE, NO_INVALIDATE => FALSE);
END;
/
ORA-20000: Unable to analyze TABLE "SAPSR3"."CCSELTAB", insufficient privileges or does not exist
ORA-06512: at "SYS.DBMS_STATS", line 34959
ORA-06512: at line 2


Read more...

Environment

  • Oracle 12c
  • SAP independent

Keywords

client copy, GATHER_TABLE_STATS, DBMS_STATS, ORA-06512, ORA-20000 , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.