Skip to Content
0
Former Member
Jun 03, 2008 at 06:52 PM

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

65 Views

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.