2610624 - ORA-20000 DBMS_STATS.GATHER_TABLE_STATS

• 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

• Oracle 12c
• SAP independent

client copy, GATHER_TABLE_STATS, DBMS_STATS, ORA-06512, ORA-20000, DBMS_STATS.GATHER_TABLE_STATS  , KBA , BC-DB-ORA , Oracle , Problem