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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.