Update statistics - BR301E SQL error -1031 at location stats_tab_collect-3

[Former Member]

Hi,

I'm having this error when update statistics is run:

+BR301E SQL error -1031 at location stats_tab_collect-3+

+ORA-01031: insufficient privileges+

+ORA-06512: at "SYS.DBMS_STATS", line 10301+

+ORA-06512: at "SYS.DBMS_STATS", line 10315+

+ORA-06512: at line 1+

The SAP was using the analyze table and I have changed to use DBMS_STATS. And now is returning this error.

Any Idea ?

Many Thanks.

[Former Member · Accepted solution]

Hi Rui,

Take a look at "Note 351163 - Creating ORACLE DB statistics using DBMS_STATS".

Best regards,

Orkun Gedik

[Former Member]

Hi Rui,

You can install latest Oracle patch from sap.service.com, also. I faced with that kind of problem and I remember that I solved this issue by applying latest patches.

[fidel_vales]

SAP Note 761745 - Oracle 9: ORA-01031 and ORA-06512 with DBMS_STATS s a very good starting point